Access 2007 - record deleted thru asp, #DELETED causes error

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Daniel Baker
    New Member
    • Jan 2011
    • 2
    #1

    Access 2007 - record deleted thru asp, #DELETED causes error

    asp deleted record, left #DELETED behind in a field.
    It causes asp reading page to stop at that record, with message "Record is Deleted". I don't think that happened with earlier version of Access. When I tried to import that table into earlier version of Access, got the same error.

    I'd be happy to make a query that would really delete the record instead of retaining the record with that #DELETED. But how?
    Tags: None
    • RuralGuy
      Recognized Expert Contributor
      • Oct 2006
      • 375
      #2
      A Requery will get a fresh Recordset that does not have the #DELETED record in it.

        Comment

        • Daniel Baker
          New Member
          • Jan 2011
          • 2
          #3
          If you mean a repeat of the select query, via asp/web, multiple repeats didn't do it. Within Access, couldn't manually delete the row. Finally, I made a delete query for where mid(xxx) = delete. But next time a delete is made from asp page, that will probably happen again. What happened in 2007 that's different?

            Comment

            Previous template Next
            Working...