get access data using ADO from an password protected mdb
Or put it in the connection Open arguments:
Dim oADOConn As ADODB.Connection
Set oADOConn = New ADODB.Connection
oADOConn.Open ConnectionString, MyDbUsername, MyDbPassword
RBS
"Ralph" wrote in message
...
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and
Settings\desktop\test.mdb;Jet OLEDB:Database Password=MyDbPassword;
"Dan" wrote:
I am currently using this connection string
Public Const ConnectionString As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and
Settings\desktop\test.mdb;Persist Security Info=False"
Now that I have added a password to my access database - how should I
change
the string to include the password.
Many thanks,
Dan
|