Hi all,
I have created a .bat file to open my database run a macro and then close. This works file however another program uses this database useing the jet engine and a password is set.
The password is not from the users and passwords section it is the database password "set database password" in access 2007.
I want to be able to run mt .bat file and carry the password along so i don't need to enter it. i have tried:
START MSACCESS.EXE "C:\Users\Justin\desktop\pwEssentials.mdb" /pwd = myDbPass"
with no success as "pwd" refers to the user/group passwords.
The above command line starts access and says enter username and password which is generally not required.
I also have a vb script to try and open it:
Set accDB = CreateObject("Access.Application")
accDB.OpenCurrentDatabase("C:\Users\Justin\desktop\pwEssentials.mdb")
accDB.CloseCurrentDatabase
accDB.Quit
but i cannot figure our were to specify the password
Cheers,
Justin
I have created a .bat file to open my database run a macro and then close. This works file however another program uses this database useing the jet engine and a password is set.
The password is not from the users and passwords section it is the database password "set database password" in access 2007.
I want to be able to run mt .bat file and carry the password along so i don't need to enter it. i have tried:
START MSACCESS.EXE "C:\Users\Justin\desktop\pwEssentials.mdb" /pwd = myDbPass"
with no success as "pwd" refers to the user/group passwords.
The above command line starts access and says enter username and password which is generally not required.
I also have a vb script to try and open it:
Set accDB = CreateObject("Access.Application")
accDB.OpenCurrentDatabase("C:\Users\Justin\desktop\pwEssentials.mdb")
accDB.CloseCurrentDatabase
accDB.Quit
but i cannot figure our were to specify the password
Cheers,
Justin
Last edited:
