Answers
May 01, 2009 - 09:10 AM
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.
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 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
The Quomon Team
Add New Comment