>Thanks for the reply. It is basically what I thought, but the problem I have with semephore locking, is when do you turn off the semaphore. How do you know the user has ended prematurely, taken too long to update, or just shutdown their Browser.
>
>It is a new world in some repects, but one that I am looking forward to solving.
>
>Thanks again.
>
>

Bret,
We also store the datetime in the lock field. With our system, we have a nightly process that runs that clears all locks from the previous day. If you are looking at a more real-time solution, you could run a server process that does the same thing on an hourly/semi-hourly basis.

This is real easy using something like Oracle or SQL Server using DBMS_JOBS or SQL Agent, respectively. With VFP, you could use the AT function on your NT/2000/XP box to run a VFP program to do the same thing. I guess you could do the same in Access (blech!).

Good luck!