Compact and Repair Error

A

AccessDbGirl

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
 
J

Jackie L

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.
 
S

Sandy

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

Access error 3059 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Compact & Repair Bug 2
Error-17099 SMTP Relay Error Problem Entourage 2004 0
Compact and repair db question 1
Compact and Repair Advice 14
Compact and Repair 12
Error When Attempting to Compact and Reapir 9

Top