I want to eliminate the Access logon using the Win2000 logon by putting it in my shortcut command line. I can get the username but can't figure out how to get it into the command line. It seems like most of the posts here deal with setting up your own security tables and not using Access built in security. I would prefer to use the Access security already set up if I can. I have even tried a batch file to get the username, assign it to a variable, and plug it into the command line, but I am just not getting it.
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "U:\COMMON\database files\database front end\training.mdb" /user environ("username"
/pwd ****** /Wrkgrp "U:\COMMON\database files\system\ppswi.mdw"
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "U:\COMMON\database files\database front end\training.mdb" /user environ("username"