I'm creating a member database for my son's scout troop, one which will be shared over the internet via IWP.

There are several scripts where I'd like to find out the account name of the person currently accessing the database over IWP. For one thing, I want to be able to log the current user's account name in the log of changes made to the database. For another thing, I'd like to be able to make certain buttons non-functional when the database is accessed by a user without write privileges. (At present, pressing those buttons without sufficient privileges sends the user [Guest] to confusing dead-ends.)

I've tried the following Get functions:

Get (AccountName) : gives the FM account for the host, not the IWP user.

Get (UserName) : gives the computer username for the host computer.

Get (PrivilegeSetName) : gives the response "[Full Access]" (i.e. from the perspective of the host computer) regardless of whether the user is logged in to IWP with full access or "read/write only" or "read only" access.

Ideas, anyone?

OK. I've discovered that Get(AccountName) works properly when used in a script step, and only gives the behavior described above when used in a calculation field.

I'm still puzzled by the behavior of Get (PrivilegeSetName) — when used in a script step or in a calculation field I get the response "[Full Access"] even when logged in over IWP as "[Guest]"

With Get (AccountName) working, I can work around the weirdness of Get (PrivilegeSetName). But if anyone has managed to get a response from Get (PrivilegeSetName) other than "[Full Access]", I'd love to hear about it.

Thanks,

Chuck Henebry

http://www.thefmkb.com/7161