I want to set the Database password, and then have an AutoExec Macro or Start-
up Form launch and automatically (behind the scenes) pass the Database
password so that the user does not have to know the passwood (invisable) and
then he can just select tasks from a menu.

How can I do that?  Thanks

Bruce

What's the point of a password which is automatically set? That seems to me
the same as no password.

Passwords are asked for before you enter the program. Therefore, it's a bit
late to do something with them within the program.

With user-level security, you can set the password on the command line (/User
/Pwd, lookup Startup command line options), but I don't know of a way with the
Database Password.

Database password only lets you in or out, if you just want to let them in
then why bother :-) If you want different users to have different options in
the program, ahhh that's different use user-level security, this lets you have
different users allowed different tasks. (if you set your forms up that way),
and you can bypass user/password entry on a given PC as above!
Chris

Show quoteHide quote

Bruce Mogayzel wrote:
You can't.  The password will be asked for before the file has a chance to run
any code or macro.

The database password is SO easily hacked that I wouldn't even bother with it.
With User Level Security you could first open a non-secured file whose only job
is to open the secured one and it could pass the proper workgroup file, user
name, and password as command line arguments and then close itself.  I don't
think you can supply the simple file password as a command line argument.

application deployment for SP2
New Post - Owner deleted - No backups, nothing!
Problem with Multi-users in Access97
Suggestion on deploying and securing an Access appl
Security in fields
Preventing design changes with share-based security
Workgroup file in Network drive and Local computer
how I add an username + posword to a mdb file?
Is it a good idea to create my own navigational buttons ??
Hiding database window