Error Message

[HD20]

I am getting an error message when trying to open my database, it reads:

The Microsfot Jet Database engine could not find the object "MSysACEs". Make sure the object exists and that you spell its name and the path name correctly.

Any ideas?

 

[The_Doc_Man]

MSysACEs is the table of access control entries for database objects. If you have a database with no ACEs on record, this database is damaged. I don't know that a "repair" would be able to do anything at all.

Search this forum for the topic "corrupted database" - in particular for those articles that discuss 3rd-party products to deconvolute and recover a damaged database.

 

[HD20]

Now I am getting a message that the file name is not an index in the table and is telling me to look in the indexes collection of the TableDef object to determine the valid index names.

 

[mstorer]

Before things get too bad for you, create a new Access database. Then import your tables, forms and queries. You can do this by clicking File ->Get External Data -> Import. Then select the damaged Database.

Unfortunately, if the database is damaged too severly, you may not be able to perform even this function. Best of luck.

 

[HD20]

You are correct, I could not do even that. I am just going to retrieve the backup from Friday. Thanks for the input though. Any ideas as to what may have caused it so I can guard against future occurances?

 

[mstorer]

I really have no idea what could cause this. To give you an example of the various problems I've encountered, our company was swapping out file servers a couple of weeks ago. When the new sever was "restored" via a tape backup, nearly all of our multiuser databases were damaged. Although, in our case, it was not a system table that was damaged, I suppose it goes to show that sometimes Access files can be truly fragile things.

 

[ghudson]

I have had a lot of success using Microsoft "free" Jet Compact Utility program for repairing databases that appeared to be beyond repair.

Search Microsoft's knowledge base for Jet Compact to find the program for your version of Access.

HTH