#Deleted record on Database

[Steve.]

I am using Access 2007. On one of my databases there is a record embeded
that has #Deleted in all fields. I tried to manually delete the record, but
when I close the database and reopen , the bad record is still there. All
queries fail when trying to read the database. I've tried to run a delete
query but it fails too. Help.

 

[golfinray]

My guess would be it is because the table or query is not editable (has the
asterisk and arrow at the bottom un-highlighted.) To get around that, pull
the info into a query then make-table to create a table that is editable.
Then delete the record.

 

[Steve.]

The Database is editable.....I can update other records with no problems. I
can not run queries - I get error message Error Occurred

 

[Steve.]

Here's the error msg:
Record is deleted. (Error 3167)
You referred to a record that you deleted or that another user in a
multiuser environment deleted. Move to another record, and then try the
operation again.

 

[John W. Vinson]

I am using Access 2007. On one of my databases there is a record embeded
that has #Deleted in all fields. I tried to manually delete the record, but
when I close the database and reopen , the bad record is still there. All
queries fail when trying to read the database. I've tried to run a delete
query but it fails too. Help.

This could be corruption. Make a backup of your database, and Compact it.

Is this a local table in your database? .accdb or .mdb? Or is it linked to
some other backend database? More info please!

 

[Allen Browne]

Steve, create a new table, and import the good records, without referring to
the bad one.

Details:
http://allenbrowne.com/ser-47.html#RowsShowDeleted