Form Lock

[napoleao]

I have split a database so it could be multi-user, my question is, how can I lock a form when someone opens it? I want to ake sure that two users are not editing the same data.

thanks

 

[MajP]

Since every user has their own front end (or at least I hope they do) then you can not lock the form because each user has their own instance of the form. AFAIK there is not possible way to determine which forms other users connected to your back end are running. However, you can determine which records are currently being edited by other users.

You should be worrying about how you lock the records not the form. Maybe here:

http://www.databasedev.co.uk/multi-user-application-record-locking.html

 

[napoleao]

thanks