You'll need a table where a new record is created each time some one opens the file. You can use Field Options to specify that the following script be run each time the file opens:
Go to Layout [ UserAccessLog (UserAccessLog)]
Go To Layout [//select the layout you want them to see on startup here]
The UserAccessLog can have just two fields, AccountName, set to auto-enter the current user's account name and AccessTimeStamp, set to auto-enter the creation time stamp. (A timestamp will record both date and time in the same field). Of course a third field can be included if needed to record the user's full name if their account name is not sufficient identification.
A simple list view layout can list all access activity logged for your database and you can sort it by account name to group the records by user.
If you take a list view layout and remove the body layout part, replacing it with a sub summary layout part "when sorted by AccountName", you can then put AccountName or the user's name field in this part to get a listing where each user is listed only once. If you add a summary field that computes the maximum of the AccessTimeStamp field and put it in the sub summary layout part, you'll get a list of each user and their most recent access time stamp.
Thanks Phil - I will try that tonight and see how I go.
Perfect - worked a treat!! Thanks