Prevent 2 person edit the same form...

ALAN

Registered User.
Local time
Today, 18:09
Joined
Jul 12, 2000
Messages
23
I have found that if 2 persons edit a same form for a same class of my school at the same time, only the last form will be saved. Can I prevent other user from editing a form of a class if the form of the same class is being edited by other user. The form is connected to a query. Help me plz...Thanks...
 
Have you split your database into backend and frontend if you have more than one user accessing the database at one time? If you haven't I would certainly recommend it. Search the forum for split database or backend frontend for a mountain of stuff on the subject. Also you can set your record level locking. Go to Tools>Options>Advanced and set the Default Open Mode to Shared and the Default Record Locking to Edited Record.

Hope that helps.

DBL
 

Users who are viewing this thread

Back
Top Bottom