This means there is some junk in the system that Access is
not handling properly. As I recall, the easiest way to
fix it is to run a Make Table query to dump all of the
(valid) data from the offending table into a new temp
table; delete the table that is causing the problem; do
the compact and repair; and then open it back up and
rename the temp table back to the original name.
Make sure you save a back up copy of the entire .mdb file
before you start this, just in case something goes amiss
in the middle of all this and you have to start the
process over.
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.
