Run Time Error 3343

[DavidRidgway]

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?

[HaxSoft]

Hi, there

Are you using DAO in your VB program to access the database? If so, I think you should be using DAO version 3.5 in your VB program to access the MS Access 2000 database.

Hope this helps you.

[PrOgGiE]

I not sure but I was under the impression that if you have Access 2000 you need to use ADO. But don't take my word for it.

[Chris]

For MS Access 2000 Database you need to use the DAO 3.6 Object instead of DAO 3.5.

There is not necesary to use ADO Object. If you project is starter from ground up, then I'll recomend to use ADO, but it not for migration project. But if you've time still can go ahead with ADO

[HaxSoft]

Hey, SORRY

Chris is absolutely right ... it is DAO version 3.6 you need. My mistake.