how to connect vb to access db....

[vikas1111]

How to connect visual basic to access database without using adodc...

[debasisdas]

Try to use ADODB.

Project ----> refrence---------> select ADO library .

[jamesd0142]

This has been covered hundreds of times, try sing the search and im sure you will find alot of information.

What version are you using?

[vikas1111]

This has been covered hundreds of times, try sing the search and im sure you will find alot of information.

What version are you using?

Hi i am using visual basic 6 and MSaccess07

[debasisdas]

Have you tried as suggested in previous posts in this thread ?

[vikas1111]

Have you tried as suggested in previous posts in this thread ?

Hi Debasis
I am not able to find adodb in the link you have provided.

[debasisdas]

Hi Debasis
I am not able to find adodb in the link you have provided.

Did you find Microsoft ActivexDataObject .

select the higher version.

[vikas1111]

How to connect visual basic to access database without using adodc...

This is the code which i have written..
Dim c As ADODB.Connectio n
Dim rs As New ADODB.Connectio n
Private Sub Form_Load()
Dim cs As String
Set myconn = New ADODB.Connectio n
myconn.Connecti onString = "provider=micro soft.jet.oledb. 4;"
dbpath = "d:/name of the file.mdb"
rs.Open "select * from name of the table which i want to access", c, adOpenStatic
Me.Text1.Text = rs(no.of column)
End Sub


ERROR I AM GETTING IS INVALID PROPERTY ASSIGNMENT

[vikas1111]

Did you find Microsoft ActivexDataObject .

select the higher version.

yes microsoft activex data object is there

[debasisdas]

You have declared c ,but using myconn