How to open a UID & PW secured DB from a script

[Guest]

My machine has to run a script to open user level secured Access database unattended. I have been wondering how I can pass user ID and password to the database inside a batch file

Any suggestions will be very much appreciated

Paul

 

[Scott McDaniel]

A standard shortcut it like this:

"Path to msaccess.exe" "path to your database" /wrkgrp "path to your
workgroup" /user "yourunsername" /pwd "Yourpassword'

your script could use this syntax ... of course, if this is a batch file
then the user/pass is just waiting out there for anyone to see, so consider
that.

Command line switches in Access 97:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q105128
--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP

My machine has to run a script to open user level secured Access database

unattended. I have been wondering how I can pass user ID and password to the
database inside a batch file.

 

[Guest]

Scott, thank you for your reply.

Is "path to workgroup" a path to the file with security settings like default System.mdw?

Sincerely,
Paul

----- Scott McDaniel wrote: -----

A standard shortcut it like this:

"Path to msaccess.exe" "path to your database" /wrkgrp "path to your
workgroup" /user "yourunsername" /pwd "Yourpassword'

your script could use this syntax ... of course, if this is a batch file
then the user/pass is just waiting out there for anyone to see, so consider
that.

Command line switches in Access 97:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q105128
--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP

My machine has to run a script to open user level secured Access database

unattended. I have been wondering how I can pass user ID and password to the
database inside a batch file.