accessing sql from vb code
Posted on 2004-10-13
I am trying to access tables in a sql database using vb6 and adodb and recordset
I have only ever done this from vb to access. I am not using any forms
to make it simple lets call the data base test and the table person. in access I think I did
Dim rs As ADODB.Recordset
Dim cn As ADODB.Connection
Dim com As ADODB.Command
'create the connection to the database.
Set cn = New ADODB.Connection
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\shayne\Desktop\firstagain\FirstResponse.mdb;"
' Get the record set.
Set rs = New ADODB.Recordset
rs.open "Select * from person"
Ok second half of hte question is how to I update the database with code.
Thanks in advance, loss newbie programmer