I have a problem compacting a 13Mb db. It gets partway through and then I get the error:
"Record(s) can't be read; no read permission MyDB.mdb".
I open the db I have compacted to - db1.mdb, and there is a MSysCompactError table, I open this and find that it is having problems compacting the MSysObjects table. True enough I go back to MyDB.mdb and I can't copy/paste this table (although it is possible to copy/paste it in all other dbs I manage).
So I'm guessing that I need a new MSysObjects table for this db (unless I want to go back and create the thing from scratch...). Does anyone have a better idea - or have come across this problem before?
Or know an easy way of creating an MSysObjects table (is it possible??).
I had a similar problem with one of my databases. I created a new database, then imported all my objects into the new, empty database (tables, queries, reports, etc). Do not import any of the MSys tables. The new database will have its own MSys tables and you should no longer have an issue with them being corrupt.