Password protection for database?

[jv2]

Hello!

Got a bit of a problem with setting passwords for admin to the database...
When I set a password for the admin... and then start another unrelated database, it will ask for the password I entered for the other database... how do I set separate passwords to each database? what is going on?

 

[ReAn]

*.mdw (something similar with a w, i think this is it) holds all that info, try creating a new db in a different folder.

 

[Brian1960]

The *.mdw file

This is where the security for Access comes form.
If you need to have different security for different databases then you need to create another MDW and when you log into the databases pass the correct mdw as a parameter. The access files are okay on this at best.

 

[jv2]

Sounds very interesting. Thanks for the tips.
I am not sure what you mean by this and the access help file does not tell me anything. Would you guys be able to explain how to go about this?
Or if you happen to know if this can be even done in Access 2.0?

Thanks for your help.

 

[Brian1960]

Workgroup files

This is the basis of starting an Access application with a specific workgroup file.

The user can use the default workgroup information file or can force Access to use a secured workgroup information file created for a specific database. To associate specific secured database files with their workgroup information files, you must create desktop shortcuts. Each desktop shortcut must have the Command-Line option set to start a specific database and use the specific workgroup information file secured with that database.

To start a secured Access database named MyApp.mdb in a folder named MyAppFolder with the workgroup information file used when establishing security on MyApp.mdb, the command-line syntax must include the /WrkGrp command-line switch, for example:
"C:\Program Files\Microsoft Office\Office\MSAccess.Exe" "C:\MyAppFolder\MyApp.MDB" /wrkgrp "C:\MyAppFolder\System.MDW"

You can create a shortcut and enter this syntax as the target of the shortcut.

For additional information about Startup Command-Line Options, look at the article in the Microsoft Knowledge Base:
209207 ACC2000: How to Use Command-Line Switches in Microsoft Access