Start Up Options

[michael.thompson]

Access 2000
I have a macro that I would like to run on the windows scheduler to
update some tables in a database.

The database is protected by a password. How can I send the password
to the database in the start up options?

The Script from the bat file:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "H:\My
Documents\Test Batch File\Test Batch File.mdb" /pwd "passwrod" /x
macUpdateMainPhysical
I am prompted for a user ID and password, then the database password.

 

[Rick Brandt]

Access 2000
I have a macro that I would like to run on the windows scheduler to
update some tables in a database.

The database is protected by a password. How can I send the password
to the database in the start up options?

The Script from the bat file:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "H:\My
Documents\Test Batch File\Test Batch File.mdb" /pwd "passwrod" /x
macUpdateMainPhysical
I am prompted for a user ID and password, then the database password.

I don't think you can. The pwd/ argument is for UserLevel security, not the
file password.

The file password is so easily bypasssed that I would solve your problem by just
removing it.