Unrecognized database format

  • Thread starter Thread starter abnewallo
  • Start date Start date
A

abnewallo

I am getting the above error when I try to access a database.

I have tried compact and repair, importing and the compact utility
'Jetcomp.exe' and nothing works.
 
Where'd you get the database? You usually will get that message if you are
trying to open a database that is in a newer format. For example, if you
were trying to open an Access 2003 format database from Access 2000.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.
 
On Sat, 1 Dec 2007 18:19:01 -0800, abnewallo

It could be corrupt beyond repair, or perhaps a newer version (e.g.
you will get this if you try to open a A2007 database in A2003).

-Tom.
 
Also, if I remember correctly this can happen if someone tries to open the
mdb file with Word, Excel, or Notepad.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.
 
abnewallo said:
I am getting the above error when I try to access a database.

I have tried compact and repair, importing and the compact utility
'Jetcomp.exe' and nothing works.
Click to expand...

So here's my standard spiel. You've done some of these already, so go down
the list:

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
 
Back
Top