Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Open mdb database with VB
- Thread starter ofsouto
- Start date
Sample below:
Assume that ADO is referenced within project
Dim cnnNorthwind As ADODB.Connection
'Create the connection.
cnnNorthwind.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Program Files\Microsoft" & _
"Office\Office\Samples\Northwind.mdb;" & _
"User Id=<UserName>;" & _
"Password=<password>;"
Assume that ADO is referenced within project
Dim cnnNorthwind As ADODB.Connection
'Create the connection.
cnnNorthwind.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Program Files\Microsoft" & _
"Office\Office\Samples\Northwind.mdb;" & _
"User Id=<UserName>;" & _
"Password=<password>;"
- Status
