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?

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?