#Deleted record on Database

  • Thread starter Thread starter Steve.
  • Start date Start date
S

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.
 
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.
 
The Database is editable.....I can update other records with no problems. I
can not run queries - I get error message Error Occurred
 
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.
 
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.
Click to expand...

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!
 
Back
Top