How to connect visual basic to access database without using adodc...
This is the code which i have written..
Dim c As ADODB.Connection
Dim rs As New ADODB.Connection
Private Sub Form_Load()
Dim cs As String
Set myconn = New ADODB.Connection
myconn.ConnectionString = "provider=microsoft.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