Help Unrecognised Database Format

[tcullen]

I'm trying to connect an Access Database to my vb project through Visual Data Addins, but when I go to open the database to create the table / link the following msg is displayed.

Error 3343 DOA.Workspace unrecognised database format

The Access DB is saved as an .MDB file I've also tried the .MDE extension but it won't accept either.

I'm using Access on Office Premium. Any ideas

[Static]

y'know...I have had this same problem a number of times. I have NO Idea what causes it.

The only way I got it to work was to re-create the DB.


No clue...hope someone has a better answer...cause doing that sucks

[Serge]

It happens because the old Data Manager is based on Jet3.5 and Access2000/XP is based on Jet 4.0.

You will have to use either DAO3.6 or ADO to access the database.

[Hack]

Lord in heaven, Serge, don't I wish I'd know that!!!!!!!

I had the same problem a while back as tcullen and, like geoff_xrx wound up recreating the Db.

[Static]

Serge ... I used to teach an intro to VB class. I had this problem occur with about 1/3 of every class. All of them were using the Same software and doing the exact same project. Used to stump me big time.

[tcullen]

Thanks guys

Problem solved.

Converted the Access Database to a previous version.