New key word not recoginized in VB6 connecting to Access

Expand Post »

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

Similar Threads

Connecting to a access database in Visual Basic 4 / 5 / 6
connecting vb to ms access 2005 in Visual Basic 4 / 5 / 6
Error message due to empty row, (VB6-ADO-ACCESS) in Visual Basic 4 / 5 / 6
vb6 sql to access in Visual Basic 4 / 5 / 6
seach a key word in a table in PHP

ZoilaResendiz

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Apr 2004

Permalink

Apr 13th, 2004

Re: New key word not recoginized in VB6 connecting to Access

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

big_k105

Team Colleague

Reputation Points: 36

Solved Threads: 2

PFO Founder

Offline

308 posts
since May 2003

Permalink

Apr 28th, 2004

Re: New key word not recoginized in VB6 connecting to Access

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

BlackDice

Reputation Points: 19

Solved Threads: 0

Light Poster

Offline

43 posts
since Apr 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Program Question...listboxes

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Preprocessor directives

DaniWeb Message

Cancel Changes

User Name
Password