Connecting a DataBase to VB

[peggyk2]

I am trying to build a front end for an Access database, but everytime I try to connect the mdb file I get an error saying it is an "unrecognized format". I can connect to Microsoft's Northwind database fine, but not my own. I am using VB6 and Access 2000.

Thank you for any help you can give me.

 

[petermeachem]

Probably because you are trying to connect as Access 97. Try using something like
"Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=d:\letters direct\Colleges.mdb"
Peter Meachem
peter@accuflight.com

 

[johnnyg123]

In the VB enviorment go to project, references check Microsoft DAO 3.6 Object Library

 

[Guest_imported]

i need a database engine to make my .EXE program work at any computer not depending on the existance of MS Access or any other program.

 

[ALSayegh]

IF YOU ARE CONNECTING AS DAO IT WILL NOT WORK
YOU SHULD CONNECT AS ADO.
GO TO REFERENCE CHOSE ADO.

MORE ...
IF YOU ARE UOSING THIS WAY
DAO..
SET RS = MyDy.OpenRrecordSet .... IT WILL NOT WORK
ELSE
ADO...
HOWTO: Open ADO Connection and Recordset Objects
GO TO

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q168336