Compact and Repair Error

[Neilbees]

Hi

Again, I've had a search, but can't find anything to solve my problem - so sorry if I've missed it.

Basically, when I compact and repair the database I'm developing at the moment, I get the error message - Table 'TempMSysAccessObjects' already exists.

There is no table of that name (or at least I can't see one and I haven't created one!) and the database just opens up again but has not compacted or repaired.

Any ideas folks?

 

[Rabbie]

There are a number of system tables that Access uses for its own purposes. They are normally hidden but you can see them by going to Tools-->Options-->View and selecting System Objects. Then when you view your tables you should see some with names starting with MSys... Don't delete any of these or Access will not work. If there is a table called TempMSysAccessObjects' you can safely delete it. Then try running Compact and repair. This should now work.

 

[Neilbees]

Great stuff Rabbie! The things you learn on this forum!

 

[Rabbie]

Glad to be of help