Using VB6 with Access 2000????

[Gaff]

Is there some kind of compatibility issues when you are linking VB6 to Access 2000. I selected the 'Microsoft DAO 3.6 Object Library’ from the references menu in VB but i'm still getting an error when i try to link the VB to the database using ADO. The error is as follows : "Unrecoginised database format", but if i convert the database to a prior version i have no problems, i'm new to Access 2000 so if someone can shed some light on this for me i'd appreciate it.
Thanks,

 

[jasek78]

OK... first of all - Why are you referencing the DAO library and using ADO? Shouldn't you be referencing the ADO library?

I've created quite a few VB programs using Access2000 databases as backends. I think if you check your references, you should be able to get it to work.

jason

 

[Ed2020]

Don't use ADO with MS Access tables - it's slower than DAO.

Ed Metcalfe.

 

[Gaff]

thanks, got it working