View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shin[_2_] Shin[_2_] is offline
external usenet poster
 
Posts: 2
Default 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.