Compact and Repair Error

G

Guest

I have a large database 91MB that, when I compact and repair it only gets
half way through then says "Access Has Encountered An Error and Now Must
Close" then asks me to send an error report or not.

I have reviewed my database and have no idea what is causing this. My only
thought is that it was built in 2000 and is now running on the Jet 8.0
service pack. Any help with this is much appreciated as I really need to
compact and repair this file.

Thank you,

Sandy S.
Database Coordinator
 
G

Guest

I have had a similar problem. Try importing all of your tables into a new
database. This is another way to get the records "clean". Then see if you
can compact the new data.
 
G

Guest

Thanks Jackie :)

That was my last resort option but it looks like the only one that will work.

Wish me luck! (Thank Goodness for Backups)
 

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

Similar Threads

Compact and repair db question 1
Compact & Repair Bug 2
Compact & Repair Corrupt Error Message 1
Compact and Repair Advice 14
Access Deleted Table after Compact and Repair Database (Access 2010) 0
Compact and Repair 12
Compact and repair deletes relationships 1
Timed Compact and Repair 2

Top