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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
paul said:
My machine has to run a script to open user level secured Access database
Click to expand...
unattended. I have been wondering how I can pass user ID and password to the
database inside a batch file.
 
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
paul said:
My machine has to run a script to open user level secured Access database
Click to expand...
unattended. I have been wondering how I can pass user ID and password to the
database inside a batch file.
 
Back
Top