Access 2010 Query is Returning "Record is Deleted"

I have tried to compact the DB, create a new DB and important all the tables into the new DB, but still getting this error


Any thoughts?
seamus9909Asked:
Who is Participating?
 
seamus9909Connect With a Mentor Author Commented:
So copy it from the Network drive to a standalone, Compact and repair, and copy it back to the network drive?
0
 
crystal (strive4peace) - Microsoft MVP, AccessConnect With a Mentor Remote Training and ProgrammingCommented:
if the database is on a network drive, move it to a local drive to compact/repair
0
 
PatHartmanConnect With a Mentor Commented:
At what point during the create and import do you get the error message?  Can you identify the table with the problem?

Create a new database WITHOUT the table in question.  Export the old table to a csv file and then import from the csv file.  

If nothing else works, restore your last backup.
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
yes -- and I would suggest doing it 3 times. Be sure to back it up before C/R.
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed.  A correct answer was given.

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.