Database with VB6

[Guest]

Hi,

Started out with VB6 a few days ago. Familiar with Access and VBA.

I'm trying to connect to an Access (.mdb) file from VB6, but the Visual Data
Manager says it cannot recognize the file type. I'm having Access 2003
installed.
Can somebody please tell me what's wrong ?

 

[Guest]

It's inadvertently been posted in this NG. Sorry for this. I'll try posting
in a VB6 NG, however, any replies are welcome.

 

[Tim Ferguson]

It's inadvertently been posted in this NG. Sorry for this. I'll try
posting in a VB6 NG, however, any replies are welcome.

VB6 is pretty antique now... you need to make sure that the ADO or DAO
libraries you are using to connect to the mdb are appropriate for the
version of Access (or Jet) that was used to create it.

Hope that helps


Tim F

 

[Douglas J. Steele]

Definitely need the correct DAO library, but the ADO library shouldn't
matter. It should only be the connection string being used that matters for
ADO.