L
Lawrie Maher
I know I should have backed up but I didn't. Can I retreive a lost database?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
[MVP]
I know I should have backed up but I didn't. Can I retreive a lost database?
Hi,
Lost where? Deleted or damaged?
If its deleted you can retrieve it by using some of the file recovery
software (unerase, undelete...), but you must run it right away after
you delete file. Otherwise Windows may use that "empty" space on HDD
and write another file. What is happening when you delete file is that
Windows mark the space file takes as deleted (available space), but it
does not delete the file until it writes another file over that space.
So, when you delete file do not take any other action than run the
files recovery software. There is a good chance you will have file
undeleted.
If its damaged, please provide more details.
Regards,
Branislav Mihaljev
Microsoft Access MVP
A
Arvin Meyer [MVP]
If the database is corrupt, here's the steps you can take:
First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.
Decompile your database:
http://www.trigeminal.com/usenet/usenet004.asp
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
First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.
Decompile your database:
http://www.trigeminal.com/usenet/usenet004.asp
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
T
Tony Toews [MVP]
Lawrie Maher said:I know I should have backed up but I didn't. Can I retreive a lost database?
If it was accidentally deleted try the free utility called
Restoration.
Tony
R
Richard
Hi,
Lost where? Deleted or damaged?
If its deleted you can retrieve it by using some of the file recovery
software (unerase, undelete...), but you must run it right away after
you delete file. Otherwise Windows may use that "empty" space on HDD
and write another file. What is happening when you delete file is that
Windows mark the space file takes as deleted (available space), but it
does not delete the file until it writes another file over that space.
So, when you delete file do not take any other action than run the
files recovery software. There is a good chance you will have file
undeleted.
If its damaged, please provide more details.
Regards,
Branislav Mihaljev
Microsoft Access MVP