I want to track who is using our database.

We are using FMP Accounts & Privileges and a custom User table in our database. (Hosted on FMPS)

Is there a way to limit each logon to only allow one concurrent use?

I have a sub table that tracks user log on and log off, but if the Server logs off someone (by inactivity) it doesn't write a line to the activity table. Is there a way to run a script when the SERVER logs out a user due to inactivity?

Boy would I love to see get(CurrentUserList) also but that is for another thread.

Jerry

The easiest way to do this is to use External Server Authentication and control the Accounts' capabilities from the Server.

Steven

Thanks for you quick and concise reply.

They have a mixed, mac/pc environment. I don't believe they can use external authentication, can they?

Jerry

They have a mixed, mac/pc environment. I don't believe they can use external authentication, can they?

Certainly they can do so. Please see the External Server Authentication Tech Brief for more details. Or post back a question here.

Steven