Linking Access 2000 to VB6 1

[TurboNutter]

When I attempt to link the 2 together, the message "unknown database type" is displayed, the correct extension (.mdb) is being used, however no access 2000 files can be linked.

If I try to link an Access 97 file it works straight away, with no problems, please help!

I am using a simple data link, not active x etc.

Mark

 

[Databaseguy]

Make reference to the DAO 3.6 and/or Access 9.0 libraries. Or, preferabbly, write your code in ADO. Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[Adam95]

If I remember corrected there is a patch for accessing Access 2000 in VB 6. I had the exact problem, go search the knowledge base. SP5 for VB6 may cure the problem.

 

[CodeFish]

Hi TurboNutter & Co.

Just a note If you are using ADO, make sure you use the correct ADO Provider:

"Microsoft.Jet.OLEDB.3.51" for Access 97

"Microsoft.Jet.OLEDB.4.0" for Access2000

Codefish