I have a DB with a "Main Menu" from this I have it setup so that other DB files are launched when a user selects a menu button. My question is this...is there a way to define how the "other" database files open (ie..privileges) based on what password the user used to open the main file...I want to have an administrative user who can edit and change files...and have those same privileges in the other DB files and clients who can only edit....

The password used to open the current file will be used to open the other files, unless the other files have a default password set.

thanks for answering my post...I'm wondering does that mean I should not have any privileges set on my other DB files in Access Privileges?

I have passwords on my "main menu" DB file... Admin and (nopassword) the no password option obviously being the one with limited privileges...I have set those same passwords up in my other DB files...problem is...if you log in as Admin to the main file...when you click on a button to have one of the other files launch..it asks for a password everytime...I can't have my users entering a password everytime they want to open a new section of the menu...is there a way to keep it from asking for a new password each time...Oh, additionally...I have a script in my main menu that automatically opens each of the other DB files in the background as Multi-User Hidden....I thought this would save time to go ahead and have them open in the background..Is that where I'm screwing up?

Your account and password info must match in each file, in order for it to work. If the DB being opened does not have the same access info as the DB file requesting the open, it will ask for account and password.

what's strange is, I have an admin and a guest account set on each file with the same privileges...but when my main menu file opens a related DB...it always asks for a password on each one. I wonder where I'm going wrong..?

OneStop,

I have found the same occurs for me if I don't have all the passwords exactly the same for every file that opens. Do you have a no password option for all the files other than the menu launcher?

I have set up the launcher file with an opening script, which minimizes the launcher, then opens all the other external files and minimizes them. See if this works for you.

Kirsten Masse

I guess your current DB design schema is base on ver FM 6 which have 1 file for 1 layout.

I don't face much difficulty when I design the whole DB under 1 file which have multi tables which replace all the 1 file 1 layout. Maybe you can convert all the files involve into the same main file which falls under different tables. With that your access priviledge administration life would be easier.

Correct me if I am wrong in my concept.