I'm an old hand at FMP6 but fairly new to FMP9. I'm working from a template of somebody else's work. In order to validate that I am indeed properly logged on with the correct identity and associated FMP privilege set, I create this calc in the same table as controls the layout layout I'll use it in. The calc itself also identifies that same table as the context.

"Current Account Name set is " & Get ( AccountName ) &

" current Privilege Set is " & Get ( PrivilegeSetName )

When logging in with a user account name and password, I would assume this should return that user's name and privilege set. But it doesn't. It returns the Admin account name and the Full Access set of privileges. This is not a cache issue because I've quit FMP9 and reloaded the solution. Same result.

What am I missing? Can you clarify what's going on?

Kind regards,

Is it unstored? These statuses, if used in calculation fields, must be unstored.

Is it unstored? These statuses, if used in calculation fields, must be unstored.

Of course! That's got it.

Thanks,

Is it unstored? These statuses, if used in calculation fields, must be unstored.

Please excuse my ignorance. I'm new to working in FMP, how do you unstore a status?

Thank you in advance!

The calculation field is set to "unstored" in the Storage options of the field definitions.

I think the problem I'm having is because of privilege sets, but I'm new to Filemaker and don't understand them. I created a file on my Mac, but when I open it on my PC, I'm unable to access anything on the Layout view - a big black square appears whenever I try to select anything. Could you walk me through how to access the same privilege set?

PC is Vista Business

The big black square is FMP hiding the layout because the user has no view privileges.

Open the file with the full access account. Check which account the file is being opened with. Then check which privilege set the account uses. In the privilege set, check the privileges set for the layouts.

I know many of you are going to think that I don't know what I'm doing, but I can assure you I have a great deal of experience with accounts and privileges. However, just in the past few days, I'm having a similar problem -- and I'm wondering if there might be some kind of bug/corruption in my files.

I've set a dialogue to tell me the account (get(accountname)) and privilege set (Get ( PrivilegeSetName ) ). It doesn't appear to be stored or cached, especially since it's a dialogue, but the account name and the privilege set don't match. In other words, even though the log-in account has specific privileges, the privileges indicated by Get ( PrivilegeSetName ) are different.

Even odder is the fact that even though Get ( PrivilegeSetName ) indicates "[Full Access]" the user doesn't, in fact, have full access.

Get ( PrivilegeSetName ) suddenly does not work in an "If" statement.

Has anyone seen this? Does anybody have a clue about what might be going on?

I know many of you are going to think that I don't know what I'm doing, but I can assure you I have a great deal of experience with accounts and privileges. However, just in the past few days, I'm having a similar problem -- and I'm wondering if there might be some kind of bug/corruption in my files.

I've set a dialogue to tell me the account (get(accountname)) and privilege set (Get ( PrivilegeSetName ) ). It doesn't appear to be stored or cached, especially since it's a dialogue, but the account name and the privilege set don't match. In other words, even though the log-in account has specific privileges, the privileges indicated by Get ( PrivilegeSetName ) are different.

Even odder is the fact that even though Get ( PrivilegeSetName ) indicates "[Full Access]" the user doesn't, in fact, have full access.

Get ( PrivilegeSetName ) suddenly does not work in an "If" statement.

Has anyone seen this? Does anybody have a clue about what might be going on?

Are you running the script with full access privileges?

Hey -- good to hear from you Genx!

Yes, full access.

It's really very odd.

Genx already gave you the answer: in the context of a script, the Get(PrivilegeSetName) function returns the script's privileges, not the user's.

But it didn't work that way previously with this particular script, and full access was checked.

Still, I unchecked it, and that corrected the problem.

Maybe I'm just really tired!

I was really tired. It had been unchecked. Thanks guys!