How do i? Shell out opening a pw protected Access Database

A

A C

Hi

We need to open in a new instance of Access a pw protected access database.
PW protected rather than users set up.

We need to shell this out from another access database, where we supply the
password in the code. For example:
'launch the database
strCmd = SysCmd(acSysCmdAccessDir) & "MSAccess.exe " & _
"""" & strSalesDatabaseFileName ####

where #### is the part we dont know how to do, and is where we tell it what
the database password is.

I tried the /pwd flag but it appears to prompt workgroup security rather
than a simple database password.

Can someone help?

Thanks
 
Top