HOW TO CONNECT ADODB.connection in VB?

Hi,

say your access file name is myaccess.mdb,
You will access it in such a way:
Set rec = New ADODB.Recordset
Set conn = New ADODB.Connection
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "myaccess.mdb" & ";Persist Security Info=False"
conn.Open (connstr), , , 0

ensure the path to your access file is correct, my sample above will look the access file in the same directory as your vb.

The question looks to be abandoned by the user who asked it. If no action is taken within 2 days, a Quomon Moderator will consider closing the question and distributing the points.

The Quomon Team