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

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

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