slreynolds
Technical User
What I would like to know is if there a way to determine if another user has a form open?
I have multiuser database that is generally wide open and all functions are available to all users all of the time.
I have one form that I would like to restrict to only one user at a time. I have set this up by having a flag field in the underlying table set to "yes" when the form is loaded and to "no" when the form is closed - the code checks to see if the flag is "yes" on open and won't let another user in if it is. This works OK 99% of the time - but if a user crashes and reboots with the flag set to "yes" then no one can open the form until I go in and manually fix it. I may want to go on vacation some day - so I'd like a cleaner solution.
Thanks
Susan
I have multiuser database that is generally wide open and all functions are available to all users all of the time.
I have one form that I would like to restrict to only one user at a time. I have set this up by having a flag field in the underlying table set to "yes" when the form is loaded and to "no" when the form is closed - the code checks to see if the flag is "yes" on open and won't let another user in if it is. This works OK 99% of the time - but if a user crashes and reboots with the flag set to "yes" then no one can open the form until I go in and manually fix it. I may want to go on vacation some day - so I'd like a cleaner solution.
Thanks
Susan
