| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
get access data using ADO from an password protected mdb
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
get access data using ADO from an password protected mdb
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| access data from a closed wb protected with password without openi | Excel Programming | |||
| Extracting data from Access Database password protected | Excel Programming | |||
| I have password protected and now cannot access it...Help | Excel Programming | |||
| How to import data from a password protected Access DB into Excel. | Excel Discussion (Misc queries) | |||
| open Access DB that is password protected | Excel Programming | |||
Linear Mode
