Access database - corrupted (?)

[Kikalo]

Hi

I have a large MS access database that is written to by three other computers. These other computers have an inhouse data logging program that when a test is finished the data is pushed to the database. Our network went down today causing the connections between the computers and server with the database to disconnect early and the database was corrupted.

In the past we have been able to apply compact and repair but we cannot seem to do anything to it. It has some crucial information from the past week (since it was last backed up) and we want to try and salvage the database before replacing it. If anyone can help I'd be very grateful.

The messages we receive are as follows:

The Database '\\Server1\db\data.mdb' needs to be repaired or isn't a database file. You or another user may have unexpectedly quit Microsoft Access while a Microsoft Access database was open. Do you want Microsoft Access to attempt to repair the database?
->
Yes
->
You do not have the necessary permissions to use the " object. Have your system administrator or the person who created this object establish the appropriate permissions for you.



Thanks all


-
Lisa

 

[danvlas]

First, create a backup copy of it (even though it's corrupted).

Then try to 'decompile' it:

Start->Run
Type
msaccess.exe /decompile "C:\Path\File.mdb"

If this does not work, you should check the Temp folder on all computers using the application, find the .tmp file created on that date and having the size of your database, change its extension to .mdb and try it...

Hope this helps,

Dan

 

[GeekGirlau]

After trying Dan's suggestions, if you still can get into the database try the JetComp utility. This is available via the Microsoft site - go to

http://www.microsoft.com

and search for "JetComp". There is an instruction sheet that is downloaded with the utility.