I have set up multiple accounts (different account names with different passwords) with the same privilege sets.

The first account I set up with this particular privilege set is able to access the database. Each consecutive account with the same privilege set has been able to access the database, but receives the error message "No Access" once it has opened.

I have set up other accounts and these work fine.

Is this normal or do I need to go about setting up new privilege sets?

Thanks for any help...

Krista

Some questions that might help narrow it down:

1. Do you have Record Level Access privileges set up for the Privilege Set?

2. Are all your tables in the same file or are some in separate files?

3. When logging in with these other accounts, are you doing a Relogin[] or Quiting and opening up the file(s) again?

Yes -- I have Record Level Access privileges set up for each Privilege Set.

All the tables in the same file -- I have the host file, and all other users are accessing from the network.

When trying to log-in with these other accounts, I have been quitting completely out of Filemaker and then trying to re-login.

My guess is the problem is in the custom privileges for the Privilege Set's Records. If the View privileges are set to "Limited..." then look closely at the calc to see if there's a reason why it's not evaluating to true (1) for those accounts. If it's a complex calc, you may have to test it in a regular calc field (unstored) to isolate the problem.