Opening Jet DB with MS Access

[agape234]

I have a db that I am told is Jet. I want to open this db with MS access but am getting Unrecognized DB format.

Easy explanation I am sure.

Any ideas.

Thanks

 

[Terpsfan]

That usually means the database is corrupt. You will have to go into the file in Access and run the repair and compact utility. I am not sure what version of Access you are using but you want to open Access first and then do a File --> Open from the menu. It will probably ask you if you want to repair the database and you say yes.

 

[danvlas]

Maybe it's created with a later version than you have...

Access 97 can't open Access 2000
Access 2000 can't open Access 2002
Access 2002 (probably) can't open Access 2003

The last two lines refer to files converted to the said formats.




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[dilettante]

There are also many sorts of "Jet" databases. But in common use a Jet database means a MDB file, probably without forms, macros, queries, and so on in it.

 

[agape234]

Repair and Compact issues the same error message. "Unrecognized database format". Not sure what to try next. Is there a way to make sure this is a Jet DB or what version it was written with etc?