How to open many files from one?

[Royce]

Greetings Fellow FileMakers -

I want to create a file that opens other files, supplying the necessary user names and pw's automatically. It keeps others who are not the current Get(UserName) from getting in, but allows a one touch opening of all the files. What is the best way to do this?

Thanks,

Royce

[Ted S]

Are you running Filemaker Server?

[Steven H. Blackwell]

Please elaborate. If you have a file that opens with an Account name and password that file can pass credentials to other files under certain conditions. Is that what you're trying to do here?

Steven

[Royce]

Let me elaborate. (And yes I am running FM Server 8). When the team comes in and starts their day, they have to open all the different files - that takes a bit of time, needing to put in a password for each secure file (almost all are, and need to be pw protected). I wanted to create a file that they open with a pw, that then opens all of the other files they use.

What I did was make all files automatically open to them (from a single pw protected file they open called openfiles) which is pw protected with a "no access" privlege and automatically relogin with their privleges based on get(username). If the username on "OPENFILES" does not equal Get(username) it terminates.

THe problem is, when a file is hiden by FM during the course of the day for whatever reason, and you try to open it again (which pulls it from the hiden files not from the server) it "un-hides" the file in "No-access" mode and does not run the startup script. So that didn't work....

I simply want to make it easy for my people to open 25 databases, with different levels of security, at one time, saving them a lot of typing. Sort of a launch FM file. I thought I had it, and it works first thing, but then during the day, I loose control or access. (Some files I guess are opened as related files, hidden, and when they open fully (brought to the front) they are brought with my no-access privleges and NOT running my relog-in ...

Thanks for the help.

Kind regards,

Royce

dataDisc CD/DVD Manufacturing

[Steven H. Blackwell]

The best way to do this is with a "menu" file that has buttons to open various other files. All files need to have the same Accounts and passwords. However those Accounts can have radically different Privilege Sets attached to them file by file. That way when users open the one menu file and click one of the buttons for the other file, their credentials information will be passed seamlessly to those other files.

Steven

[Royce]

Steven -

Let's say all my files have 10 users and 10 passwords (with five different priv. sets). Are you saying that the menu file you are suggesting, (with username and password) will pass the credentials to the file it is opening? Is that only if they are related? (Or referenced?)

And if I script those menu buttons, why not also add a script to open all of the files at once?

Thanks,

Royce

[Steven H. Blackwell]

As ;omg as the credentials are the same, they will get passed. As yes, you can script all to open at the same time.

Steven

[Royce]

Thanks Steven - all worked well...

Best regards,

Royce