Hi, I want to put a portal on my home/initial screen that shows the users currently logged into the system. I made a simple database called UsersLoggedIn with 1 field, Username, and set it to autoenter creation account name. I then set the login script to create a new record and the closedown script to search for the record and delete it when the user logs out. The problem I'm having is what happens if the database for whatever reason crashes? Besides making a button to reset the logged in users would there be any way to detect that the file is being opened with no other users on it?

Also does Filemaker Pro itself keep a record of the accounts currently accessing it or is everything handled by Filemaker Server? I'm wondering if maybe there's an easier built in way to go about this.

Alternatively, you could create a layout with one unstored calculated field for each user. Use an If function, like If (Get (Account) = "Young Padawan" ); "IN"; "OUT" ). Test this.