I am trying to access a database(mydatabase.mdb) using Visual Basic 5.0(6.0). How can I access the data WITHOUT using a data control?
Thanks in advance
Printable View
I am trying to access a database(mydatabase.mdb) using Visual Basic 5.0(6.0). How can I access the data WITHOUT using a data control?
Thanks in advance
add a reference to ms active x data object objects 2.x
dim rs as recordset
dim cn as new connection
cn.connectionstring = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=c:\my\path\to\database.mdb"
cn.open
set rs = cn.execute("select * from mytable")
msgbox rs.fields("fieldname").value
All done
HTH
Tom