New key word not recoginized in VB6 connecting to Access

[ZoilaResendiz]

Hi,

I am trying to connect to a Microsoft Access DB using VB6, when I create a new connection I Dim DB as Connection, then Set db = New Connection. When the program is ran the complier doesn't recognize the word 'New'. Is there a link I can go to in order to research more about ODBC in order to connect to a Microsoft Access db using VB6. I am trying to look for the correct syntax in order to connect to the DB.

Any help would be appreciated.

Thank You,
Zoila

[big_k105]

first take alook at this thread and it should help you out
http://daniweb.com/techtalkforums/showthread.php?t=272

and if you need alittle more info come on back or do a quick little google search on ODBC Access VB6 hope this helps

[BlackDice]

I think that's probably a problem with your references. Go to Project->References and look at your references, it should tell you if something is missing. and if you're using ado, make sure you're using adodb.connection