Access (2002) XP - Corruption Issues?

[smedvid]

I've had more corrupt MS Access XP databases over the last couple of months than I did over the last couple of years with Access-2000 and Access-97.

What is the "Best" Approach to attempt to salvage a corrupt database?

Other than the Obvious, menu option for Repair/Compact; I already tried JetComp.exe and also attempted to import objects into a new database without success. I've seen some of the Tools available to "recover" Access databases, but are they really worth the expense?

Fortunately, from experience, I store my development databases on the network and backup myself daily via WinZip at a minimum. Bad news is I can lose a day of programming. The network backup is nightly and my WinZip backups are at sporatic times of the day.

tia,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[Bennie]

I have had the same problem and I have created a blank DB and imported from the corrupt DB to the New DB. This has corrected the corruption. hope this helps

 

[psemianonymous]

It looks like you have a firm handle on how to deal with Access corruption, so I have no advice for you, besides reaffirming your backup policy.

Check out my link to Tony Toews' FAQ on corruption; it has everything.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

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