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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top