Automate Logon

[Guest]

Hello
How to use a command line to automate the logon.
I used C:\Database\Chem\EasyTrack.mdb /user bassel/pwd 1234
but it didn't work. The logon screen pop up asking for password.

Can anybody help me.
Thank you and best regards

 

[Joan Wild]

You need to include the full path to msaccess.exe when you use switches.
Also you need a space after the 'l' in bassel...bassel /pwd

 

[Guest]

Thank you for your reply.
It worked.
I have another question. I used the window scheduler to open the database
execute a query.
How to close the database auto after that

 

[Joan Wild]

How are you getting the query to execute? Are you using the /x switch to
run a macro? If so you should be able to add the Quit action to your macro.