If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Deleted MDB file
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. |
#2
|
|||
|
|||
Deleted MDB file
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...b;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...b;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 -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Ian" wrote in message ... 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. |
#3
|
|||
|
|||
Deleted MDB file
Thanks Arvin,
I will follow your suggestions, and fingers crossed, I might get my file back. Thanks again, Ian. "Arvin Meyer [MVP]" wrote: 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...b;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...b;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 -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Ian" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|