vb code to access database - help reqd.

[BalaC]

Hi,

Some time ago a friend's friend showed me a sample project to access the tables in MS Access directly through vb code. I couldn't see any ADO control on any of the forms. The ActiveX Objects library was however included in the project references.
I tried to do the same thing on my own with a trial project using the Northwind database, but failed. I get the following error messages: connection is closed or the object is not found or method not found.

I included the following statements like him in the project.

Under General declarations:

Option Explicit
Public conXYZ as ADODB connection
 
Under Formload:
 
Private Sub Form_Load()
 
Set conXYZ = New Connection
    conXYZ.CursorLocation = adUseClient
 
 
    conXYZ.Open "Driver={Microsoft Access Driver(*.mdb)};DBQ=C:\Test.mdb;UID=admin;PWD=testdb;"
End Sub
 
 
where test.mdb is a copy I made of of the northwind database.
Unfortunately I have lost touch with the guy. Can any one help?

[Dököll]

Hi,

Some time ago a friend's friend showed me a sample project to access the tables in MS Access directly through vb code. I couldn't see any ADO control on any of the forms. The ActiveX Objects library was however included in the project references.
I tried to do the same thing on my own with a trial project using the Northwind database, but failed. I get the following error messages: connection is closed or the object is not found or method not found.

I included the following statements like him in the project.

Under General declarations:

Option Explicit
Public conXYZ as ADODB connection
 
Under Formload:
 
Private Sub Form_Load()
 
Set conXYZ = New Connection
    conXYZ.CursorLocation = adUseClient
 
 
    conXYZ.Open "Driver={Microsoft Access Driver(*.mdb)};DBQ=C:\Test.mdb;UID=admin;PWD=testdb;"
End Sub
 
 
where test.mdb is a copy I made of of the northwind database.
Unfortunately I have lost touch with the guy. Can any one help?

You have the markings of s skilled programmer, if this is your code. I actually have no clue. I must say though I have just posted a code in DAO I think might be helpful:

http://bytes.com/forum/thread790879.html

Dököll

[BalaC]

What does the highlighted word 'subscribed' at the bottom of the posting mean? -Bala