VB6 and Access 2000 Help

[cleolab]

I have VB6 sp3, that's a little old, got it in early '99. When I create a db in access2000, vb says it can't recognize db format. Is there an upgrade i can get for this?

[HDR]

Which Access library are you referencing in your project?

yep.

that's the key...

[Sal]

I had the same problem. It is DAO! You must use ADO or reconfigure the jet engine. Access 2000 uses Jet 4.0 Therefore, the jet engine for Access 2000 is not compatible with the Jet 3.5 I believe it is.

Looking for MS-Article... Found it...

http://support.microsoft.com/support.../Q238/4/01.ASP

The error message which initially plagued me was "Run-time error 3343 Unrecognized Database Format XXX "

Hopefully this helps!

Sal

[ALFA117]

i HAVE THE SAME PROBLEM...
tHE SOLUTION TO THIS PROBLEM
-WITH ADO: IS TO USE "MICROSOFT.JET.OLEDB.4.0"
bUT I CAN´T FIND IT ANYWHERE

hELP PLEASE!!!
[email protected]

[mlana]

e-mail me at [email protected] and i can e-mail you .exe that would provide your system with jet 4.0 DAO library.

[cleolab]

First, Thank you all for your help!

Second, let me see if I'm getting this.

Access 2000 uses Jet 4.0
VB6 is using Jet 3.5 , thus the conflict.

Now I've found that both Jet types are on my computer, but how do I configure 3.5 to be the default jet? Or vice versa.

Again, Thank you.

[mlana]

You still need DAO 3.6 type library - DAO360.DLL to work with Access 2000.

so what exactly needs to be done in order to use access 2000? what code or references need to be added? thansk guys i guess i just dont get it yet