I had problems compacting a database - it was ging and error that I did not have read access to the tables.
I spent a while checking and found it was one of the mSys tables that was not letting me in. Repair ran, but did not help, and trying to manually import all the items gave a similar error when you reached forms.
Simple solution:
The temporary table created whn compacting was fine and error free. Rename the working file, and the find the db1.mdb fiel and rename it to be your working file.
Remember, if you have been doing this a while, you may have db1.mdb to db999.mdb. All the temporary ones can be deleted once you are happy you have a working version.
I spent a while checking and found it was one of the mSys tables that was not letting me in. Repair ran, but did not help, and trying to manually import all the items gave a similar error when you reached forms.
Simple solution:
The temporary table created whn compacting was fine and error free. Rename the working file, and the find the db1.mdb fiel and rename it to be your working file.
Remember, if you have been doing this a while, you may have db1.mdb to db999.mdb. All the temporary ones can be deleted once you are happy you have a working version.
