Access opens with the symbol

[reyes]

We are getting this error when opening our Access 2007 database " Object 'MSysCompactError' already exists" and when it open all the boxes are filed with the symbol #
Does anyone know how we can fix this, we have tried restoring the file  from several days and the same is happening. I make sure everyone was out of the database when we restore it.

This is MS Access 2007 on Windows 7 computers.

[Graversen]

Before doing anything else, make a copy of your database.

First make sure that your installation of Windows and Office is fully up to date.

Try importing everything to a new, blank database. To do that, create a new database, then use the External Data ribbon item, select Access, then select the trouble db and try to import everything to the new one.

If that doesn't work, you might try a compact operation, but if you can't open the database you may have troubles with that. You can compact from another database via code:

DBEngine.CompactDatabase "full path to the trouble db", "Full path to a different db"

Note the second db (the "full path to a different db") does not need to exist.

If that doesn't work, you might need to enlist the aid of a 3rd party to help. Access Recovery Toolbox at  http://www.oemailrecovery.com/access_recovery.html  does a very good job of recovering Access databases.

Perhaps this topic is on the Microsoft something to help.  https://social.technet.microsoft.com/Forums/en-US/bd28d11c-e9c1-4a4c-8268-ba482c693601/my-edb-file-corrupted-in-exchange-server?forum=exchangesvrclients

[reyes]

You've been very kind in your efforts to help. Thanks for that. Solved!
 

Edited July 21, 2016 by reyes