Does anyone know a way to tell if there is a Guest connected to a database that is Hosted by FileMaker Pro(not FileMaker Server)? I know, I know...using FileMaker Server would solve this problem. But, I have a client who just won't spend the $$.

I tried running a script with Error Capture On that tried to access the Define Fields, but the first thing that comes up is that FileMaker is waiting for a Guest to disconnect. Then, it doesn't return an error.

Use user count status function:

If [status(CurrentUserCount)<2]

* No other users, so do your stuff here

End If

Thanks again Bob! I didn't even realize there was a status function for counting the number of users.

In the file (on your server) choose the Sharing command from the File menu. It will tell you how many guests are using the file.

Thanks Vaughn. That's another great method that I have probably seen a million times and for some reason didn't think of it. Well, that's what makes this forum great...Hundreds of FileMaker thinking minds all in one place.