MSysCompactError 1

[supportguy21]

I have created a support log database that is stored on our company's network drive so it can be accessed by several (designated) users.

The following error message now appears when the database is closed:

"Table 'TempMSysAccessObjects' already exists"

When I click the HELP button, I receive the following message:

********************************************
Table <name> already exists. (Error 3010)
You tried to create or rename a table with a name that already exists in this database. Choose another name, and then try the operation again.

In a multiuser database, this error can also occur if you delete a table, another user creates a table with the same name, and then you try to roll back the deletion of your table. To restore your table, the other user must first delete or rename the new table before you try the rollback operation again.
*********************************************

I have also noticed a new table has been created called &quot;MSysCompactError&quot;. I have tried to delete this table but I still get an error.

My questions:
1. What caused this error?
2. How can I fix it?

Regards, SG

 

[montrose]

SG, I think you've got corruption in your database. This site

http://www.granite.ab.ca/access/corruptmdbs.htm

will give you more info. HTH, Montrose Learn what you can and share what you know.

 

[Gazonice]

During compact, Access backs up a file called: 'MSysAccessObjects' the backup is called: 'TempMSysAccessObjects'

When the compact is completed the 'TempMSysAccessObjects' is removed. If an error occurs, the 'TempMSysAccessObjects' may not be removed, and it stops the compact process happening again.

To fix this, go to 'tools' , 'options' and tick the 'system objects', this shows system objects. In tables look for 'TempMSysAccessObjects' and delete it. Then go back and hide 'system objects'

Your database should now compact again.

Garry

 

[supportguy21]

Yes Garry - problem corrected. Much appreciated.

SG21