Repairing damaged dbs

  • Thread starter Thread starter Matt Ludbrook
  • Start date Start date
M

Matt Ludbrook

My computer crashed and seems to have corrupted my
database. When I open the file it says, "Unrecognized
database format". Access couldn't compact it. Having
consulted help, I downloaded JetCU40 which told me (in
the accompanying Word doc) that the error message I got
should be something it could fix ( I assume MS Office Pro
2003 uses Jet Engine 4) but when I try and compact it
says, "Can't compact this version of database". I only
really need to pull out the queries and forms, is there
any other way of getting at them?
 
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

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
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
You said "I assume MS Office Pro 2003 uses Jet Engine 4", but it is possible for
MS Office 2000, XP, 2003 to also create a MSDE database which is more like a
stripped down version of SQL.

Cheers
 
Back
Top