PDA

Click to See Complete Forum and Search --> : Run Time Error 3343


DavidRidgway
Jun 4th, 2000, 09:26 PM
I have VB 6.0 programs that use Access 97 databases.

We are switching over to Office 2000 and after I convert the 97 database to 2000 and try to use the VB Program, I get Run Time error 3343 "Unrecognized database format".

We can open the converted database in Access but not through the VB programs.

Can anyone help me with this problem please?

Mongo
Jun 4th, 2000, 10:31 PM
If you are using DAO, check your VB reference version. If you were using AC97, you may have had DAO 3.5 (Dao350.dll) by default.

DAO 3.5 uses Jet 3.5, which can only open Jet 3.5 format (or earlier) databases. Access 2000 uses Jet 4.0-format database files, which are unrecognizable to Jet 3.5. To successfully open an Access 2000 database using the MFC DAO classes, you need to use DAO 3.6 (Dao360.dll). DAO 3.6 uses Jet 4.0, which can open any available format Access database.

I don't have the specs for ADO on-hand (if you're using ADO), but this may also be true for it as well. Hope this helps.