I'm trying to set up a batch file to open an .mdb. This would run unattended during the night. So far I have:
START "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Folder\RevSchedules.mdb" /wrkgrp "L:\ITStuff\Workgroup.mdw" /user GoodUser /pwd MagicWord
This doesn't work because we have a security account log-in password that requires the user to log in to the workgroup, before opening Access at all. It's not the same as a database password. The following line, typed in to the Start-Run command line, does open the db without prompting for the log-in, but I can't figure out how to automate it:
MSACCESS.exe C:\Folder\RevSchedules.mdb /User GoodUser /Pwd SecretWord
I have found an article in the MSKB that describes the problem, but doesn't say anything can be done about it! Does anyone know how to set this up in the command line?
Thanks!
START "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Folder\RevSchedules.mdb" /wrkgrp "L:\ITStuff\Workgroup.mdw" /user GoodUser /pwd MagicWord
This doesn't work because we have a security account log-in password that requires the user to log in to the workgroup, before opening Access at all. It's not the same as a database password. The following line, typed in to the Start-Run command line, does open the db without prompting for the log-in, but I can't figure out how to automate it:
MSACCESS.exe C:\Folder\RevSchedules.mdb /User GoodUser /Pwd SecretWord
I have found an article in the MSKB that describes the problem, but doesn't say anything can be done about it! Does anyone know how to set this up in the command line?
Thanks!