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
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