Cannot Delete Record in Table

[lucybelle]

I have a spit Access 2003 database and in one of the tables there is a record that has "#ERROR" in every field. When I try to delete the record, I get this message, "Invalid Argument". The database will not function unless the record is deleted. Can anyone tell me the easiest way to get rid of that record?

 

[jrbarnett]

Can you do this by opening the back end in Access and removing it directly?
(Ensure nobody is using the system at the time).

John

 

[genomon]

#ERROR" means there is no data to display - usually on a linked ODBC table. If this is the case, refresh the link.

Money can't buy happiness -- but somehow it's more comfortable to cry in a Corvette than in a Yugo.

 

[lucybelle]

I opened the backend exclusively and cannot delete. I deleted the link and linked it back and still the same.

This is a database that I converted the FE from Access 97 to Access 2003 last year and had no problems, until I just converted the BE in November and having problems.

To fix this problem, I copied the data in a new table and it works fine for now until it happens again.

Thanks for the suggestions.