Deleted MDB file

[Ian]

I use an SD card as means of transporting my mdb file between work and home.
I foolishly deleted this mdb file from my SD card in preparation for putting
the current mdb file on there without realising I had made a larger number of
new queries on the SD version, my own fault I know.

I found a utility to undelete files (UndeleteOnClick) and it appeared that I
had recovered the lost mdb, the file size looked right and the file had the
MS Access icon when viewing the file in Windows Explorer. However, when I
tried to open the file in Access I got the error message: Unrecognized
database format 'C:\..path to my file..'

Does anybody know how to get around this Access error message or can you
point me to a more reliable recovery utility?? I hope you can help me to get
back a lot of lost hard work.

Many thanks,
Ian.

 

[Arvin Meyer [MVP]]

Your database is probably corrupt. You may be able to save it however:

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

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

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com

 

[Ian]

Thanks Arvin,

I will follow your suggestions, and fingers crossed, I might get my file
back.

Thanks again,
Ian.