Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
open Access DB that is password protected
I have the following code written in Excel VBA to open an
Access DB: Set db = OpenDatabase("I:\test.mdb") However, the DB is password protected. Is there anyway I can write code to open the DB in the background? I know how to do this for Excel but can't figure out how to do it for Access. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
open Access DB that is password protected
ADO connection strings with security? No problem:
http://www.able-consulting.com/MDAC/...orMicrosoftJet DAO? I've no idea of a similar resource. I guess ADO is more widely used and therefore more support is available. I'd recommend switching to ADO if you can. -- "Shin" wrote in message ... I have the following code written in Excel VBA to open an Access DB: Set db = OpenDatabase("I:\test.mdb") However, the DB is password protected. Is there anyway I can write code to open the DB in the background? I know how to do this for Excel but can't figure out how to do it for Access. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PAssword protected file will not open | Excel Discussion (Misc queries) | |||
Access to password protected workbook | Excel Discussion (Misc queries) | |||
Obtaining access to protected files you dont know password for | Excel Discussion (Misc queries) | |||
How to access protected spreadsheet without the password? | Excel Discussion (Misc queries) | |||
How to import data from a password protected Access DB into Excel. | Excel Discussion (Misc queries) |