Yes you can. You do not need Access installed on your machine to access *.MDB files using
VB and ADO.
Here is some sample code:
Code:
Dim cn as ADODB.Connection
Dim rs as ADODB.Recordset
Set cn = new ADODB.Connection
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Password=TestPass;Data Source=C:\Test.mdb;Persist Security Info=False;Exclusive=0"
cn.open
set rs = new ADODB.recordset
rs.ActiveConnection = cn
rs.Open "SELECT * FROM Table1"
rs.Close
cn.Close
Set rs=Nothing
Set cn = Nothing
dBforums
>
Is this possible?
Is this possible?
06-28-04, 12:22
Linear Mode
