I currently use %username% in the command line for all db shortcuts to default the logon name to the current windows user.
I'd like to take the next step and default the password to the windows password as entered by the current user. If both the windows and DB passwords are the same they would be automatically authenticated to the DB otherwise they would be prompted for the correct pwd.
Has anyone managed to do this? Neither %password% or %userpassword% seem to do the trick.
D:\APPS\MSOFFICE\Office\MSACCESS.EXE "N:\DBS\YourDB.mdb" /WRKGRP "N:\DBS\YourWorkgroupFile.mdw" /user %username% /pwd %password%
Thanks Dave
I'd like to take the next step and default the password to the windows password as entered by the current user. If both the windows and DB passwords are the same they would be automatically authenticated to the DB otherwise they would be prompted for the correct pwd.
Has anyone managed to do this? Neither %password% or %userpassword% seem to do the trick.
D:\APPS\MSOFFICE\Office\MSACCESS.EXE "N:\DBS\YourDB.mdb" /WRKGRP "N:\DBS\YourWorkgroupFile.mdw" /user %username% /pwd %password%
Thanks Dave