protecting multiple databases

[ruthcarlton]

I have a Mutli-database system, which are all secured with passwords. For the most part, the interface is seemless and the user works in one window, but the system asks for a password everytime another DB is opened.

Is there a way to have the user enter their password only once, yet protect all 6 DBs?

[Bob White]

Nested passwords! If your main file is password protected and is sending an open file command to the second file and it encounters the password requirement, by default, it first tries to get in the second database using the password that opened the main file. If the password is the same, you right on in without even seeing a password dialog box. If the password is different, of course, as usual, you would encounter the password dialog box. So if User # 1 uses "radio" to get in the main database, assign User # 1 "radio" in the second database. Hope this solves your problem.

[Kurt Knippel]

Even better is to set the default password in the document preferences so that each database opens by DEFAULT with a given password, usually at the lowest security level.

This will not invalidate the process that bobwhite described, but is an additional level of security.

[ruthcarlton]

thanks for your response. The DBs don't open with "Open" Commands, generally they are portals or related fields and they ask for a password even when the passwords are the same.

[Kurt Knippel]

That means that the passwords are NOT the same, sorry!

[ruthcarlton]

OK. I set the default password to a password with limited access. Now how do I get back in?

[Kurt Knippel]

Same as always. Hold down the shift/option key when you launch the file and enter the higher level password.

[Kundinger]

Hello RC,

I have created similar