May 01, 2009 - 09:10 AM
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.
May 23, 2009 - 12:46 PM
The Quomon Team