Software

Ask something
Discussion Locked

Broken Access database

0 helpful
4 replies

by _degan_

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

This morning we had an Access 97 database. Using Acess 97 the database administrator made a design change to a query. Attempting to save this change, she recieved an error. Re-entering the database from Access 2000, a repair/upgrade process started, but failed. When attempting to open database in Access 2000, you get the error, "Could not create; no modify design permission for table or query 'MSysAccessObjects'" When attempting to open database in Access 97, you get an Invalid Format error.
Of course, there is no backup.
Is there anyway to recover? Are there any data recovery services which can help?

4 replies

by calves

Is the owner of the database logged on to the machine that has Access2000?
Have you tried open Access and use the Database Utilities under Tools, b4 tring to open the damaged DB? There are two options, Repair/Compact Database and Convert DB to current Version.

Have you try using the administrator password to logon, then take ownership of the db file, then try making the changes?

calves

by _degan_

Tried all of this, with no results. Paid Microsoft to take us basically through the same thing with the same result. They suggested www.pksolutions.com, who were able to take the file and recover 12 of 17 tables. Well worth the price.

This discussion is closed to new replies.