FileMaker 7.0v3

50 plus files - each with one table per file

Hosted without FM Server

Each file has 3 types of accounts setup: Full Acess, Edit or Read Only.

Each individual file uses the same Username & passowrd. different for each subset (Full, Edit, Read Only) but consistent throughout each of the 50 plus files.

How can users now access multiple files without having to log in to each file seperately?

After the initial login in the first file, then accessing a related file (or accessing a value list or script in another file), FileMaker will first attempt to use the same account name and password that was used for the first file. So if the files have the same account names and passwords, they will authenticate on the fly and simply open as needed.

You really may want to look both at your file architecture and your hosting methiods. Chanegs in both will yield vast improvements.

Steven

Could you elaborate a little? What changes and what improvements?

As a starter, try consolidating these separate files into a fewer files, each with multiple tables.

Second, try using FileMaker Server. It provides for more robust hosting and it simplifies the Account management enormously.

Steven

OK, I finally had time to work with this. My initial problem seems to have stemmed from one file having they password entered incorrectly. However, after I corrected this I still need to enter the Account Name and Password if I want open most any of the hosted files.

In reading deeper into your reply I note you state "After the initial login in the first file, then accessing a related file...". My users will need to access files that may not be related.

So if I undertsnad correctly this means I need a file for them to open that will relate to all the files? Then from this file they can open all the other files? Which in essence makes the Open Remote feature useless (besides to open the one file) and seems to defeat the purpose of "Hosting" the files since the users will have to open all the files at once (through the initial Open Remopte file)?

Hopefully I am missing something simple.