• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1438
  • Last Modified:

"Record is deleted" error

I have a replicated database that I need to make design changes to.  I've opened a new, blank database and want to import the objects from the design master so I can redesign and test changes but one table, the main table for the database, keeps giving me a "Record is deleted" error.  I've tried exporting to Excel with the same results.  I can export the table defnitions only from the original design master but I'd like to get the data as well.

Any ideas would be appreciated!
0
bhiler
Asked:
bhiler
  • 2
1 Solution
 
dsatherCommented:
have you tried linking to the table and then running a make table query from the linked table?
0
 
bhilerAuthor Commented:
Nope.....didn't think of that one!

Thanks so much!
0
 
bhilerAuthor Commented:
Got busy at work this afternoon.....any idea why I would be getting that error?
0
 
PaurthsCommented:
This is what Microsoft says: This behavior can occur if either the object or the database is damaged. Damage can occur, for example, if two users try to modify the same record in a table, and then one of them forces Access to close by shutting down the computer.

I've had the same problem, and when i open the table, it actually shows #DELETED in each field for that particular record.

A compact & repair worked for me.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now