kpurchase
asked on
Open Password Protected Access Database via Command Line or Batch File
Description pretty much says it all.. Here's what I am trying.. While it opens up the database the login dialog box still appears..
"C:\Program Files (x86)\Microsoft Office 2003\OFFICE11\MSACCESS.EXE" /pwd PASSWORD /user USERNAME /wrkgrp "\\QARCdb\users\database\QARC.mdw" "C:\Data\Max\Live\QARC2003.mde"
ASKER
That makes
="USERNAME"
appear in the Name: text box of the logon dialog box interestingly enough.
="USERNAME"
appear in the Name: text box of the logon dialog box interestingly enough.
Well ... this is an example I have that came from a Q here at some point.
Open with User Name and Password with Workgroup
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.E XE" /wrkgrp \\cotserver\vol1\departmen ts\fire\da tabases\ci tyfire.mdw "\\cotserver\vol1\departme nts\fire\d atabases\c ityfire personnel.mdb" /user="jammer" /pwd="pass"
Also, see these links:
http://support.microsoft.com/kb/209207
http://www.vb123.com/workbench/help/commandline.htm
http://office.microsoft.com/en-us/access/HP051883001033.aspx
Open with User Name and Password with Workgroup
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.E
Also, see these links:
http://support.microsoft.com/kb/209207
http://www.vb123.com/workbench/help/commandline.htm
http://office.microsoft.com/en-us/access/HP051883001033.aspx
If this is a database protected ONLY by a database password, then you cannot use a commandline parameter to do this.
if this is secured by ULS, then you can use the command line parameters as mx suggests.
if this is secured by ULS, then you can use the command line parameters as mx suggests.
I was assuming ULS since the original post showed
/wrkgrp "\\QARCdb\users\database\Q ARC.mdw" "C:\Data\Max\Live\QARC2003 .mde"
^^^^^^^
mx
/wrkgrp "\\QARCdb\users\database\Q
^^^^^^^
mx
ASKER
Hey guys it is not a database password but a password protected database with an associated (and required) mdw.. And using the code stated above gives me the same result where no password is placed into the password logon box and the username box has "=Brandon" (including the quotes). So I am not sure what I am doing wrong.. Here is what I am using now...
"C:\Program Files\Microsoft Office 2003\OFFICE11\MSACCESS.EXE " /wrkgrp "\\QARCdb\users\database\Q ARC.mdw" "C:\Data\Max\Live\QARC2003 .mdb" /user="Brandon" /pwd="123"
"C:\Program Files\Microsoft Office 2003\OFFICE11\MSACCESS.EXE
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Also: You were presented with the login box since Access couldn't find a user name "=Brandon" ... if the Brandon user exists with a password of "123", then you won't see the login box.
ASKER
That gets the username correctly entered but leaves the password entry blank still..
ASKER
Tried it with a different username and password and it worked perfectly... thanks.
"You don't use the "=" with these parameters; "
Scott ... I realized that example I posted was something you posted quite some time ago (I'm pretty sure). It had "=Scott" ... which I changed to "jammer"
mx
Scott ... I realized that example I posted was something you posted quite some time ago (I'm pretty sure). It had "=Scott" ... which I changed to "jammer"
mx
That doesn't surprise me <g> ....
If you're still getting the password prompt, then it would seem the Password you're passing in is incorrect.
If you're still getting the password prompt, then it would seem the Password you're passing in is incorrect.
"C:\Program Files (x86)\Microsoft Office 2003\OFFICE11\MSACCESS.EXE
mx