Automate Logon

B

Bassel

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
 
J

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
 
B

Bassel

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
 
J

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.
 
Top