Open and log in to database through batch file

[spacekowboy]

Hi, we are trying to automate a process. Is it possible to pass the username and password of the database through a batch file?

I have this so far that prompts for the password:

"C:\Program Files (x86)\Microsoft Office\Office15\MSACCESS.EXE" "\\path_to_database\database.mdb" /wrkgrp "\\path_to_mdw_file\wrkg.mdw"



Any help on this would be appreciated

[ItsMe]

If there is, it does not sound like a lot of fun. I have managed to use VBA to get the handle of dialog boxes. They are usually a child to the main app's Window. Not sure how you would pass that info back to the script. It might be easier to bypass the MDW.

[spacekowboy]

I did find some command line switches to try on this site:

https://support.microsoft.com/en-us/kb/209207

[ItsMe]

What happens if you supply the pwd switch and not the mdw path? Maybe if you practice with a shortcut straight to the MDW and provide the switch within the shortcut.

[HiTechCoach]

Another Microsoft KB: https://support.office.com/en-us/art...8-1F5DF9702BF1

Try add the switches /user and /pwd

Try this order:

C:\Program Files (x86)\Microsoft Office\Office15\MSACCESS.EXE" "\\path_to_database\database.mdb" /nostartup /user USERNAMNE /pwd *** /wrkgrp "\\path_to_mdw_file\wrkg.mdw"

[ItsMe]

...
Try add the switches /user and /pwd

Try this order:
...

That looks promising. Nice touch using nostartup.

[HiTechCoach]

Let us know if that works for you.

[spacekowboy]

It looks like that is going to work! Many thanks!

[ItsMe]

It looks like that is going to work! Many thanks!

Were you able to supply the path to the MDW after the user and pwd switch?

[spacekowboy]

No, before