I've got a shared solution hosted on FMS7A. I'm running FMD7 and doing some final testing before rolling the solution out to about 20 users who will access with FMP7 and the web. All copies of FileMaker have been updated to v3.

The solution has a startup script that uses a Get (PrivilegeSetName) step to route the users to the appropriate layout. It is enabled in the File Options dialog and is also set to Run with full access privileges. The script doesn't work when I test it. I have a field that displays the privilege set name. I can verify the privilege set, but it doesn't take me to the correct layout at login. I really hope this is something simple. I'm stumped.

Forgot to mention that the privilege set has access to the layout (Data Access and Design section of the Edit Privilege Set dialog) specified in the startup script.

Can you post the steps in your startup script or attach a pdf of it?

If you are using the Get(PrivilegeSet), then depending on how you the database opens, you may have to add a relogin step.

You might also try the Get(UserName), or Get(SystemIPAddress). The user name is specified in the program under Preferences.

"... set to Run with full access privileges"

This is the problem.

Think about it. You've told FMP to run the script with full privileges: this over-rides the current user's privileges.

The solution is to NOT run the startup script with full privileges. OR as Hurican suggests, do something with the UserName (but that'd be a lot of work and a maintenance headache).

Duh! I should have noticed that. Good call, Vaughan.

I got caught on *exactly* the same thing myself!