Compacting db loses data

M

Mo

Access 2k with all updates and SPs:

When compacting a particular db deletes 1000s or records from one particular
table. I can't see a problem with the data in that table, but I also get
error messgaes if I try to append the data from that table into another
table or to import it into another db.

We've had to go back to a restored copy and have lost 1 days worth of data.
Not terrible, but I have no idea what is causing this.

Has anyone seen this before?

TIA,

Mo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top