Record Locking - Help me avoid further corruption!

pianoprodigy

Registered User.
Local time
Yesterday, 21:57
Joined
Apr 22, 2003
Messages
42
Ok, here's the deal. I'm tired of fixing our gigantic table because of corrupt records in my firm's database. I find that the problem ordinarily comes up when someone opens the same record in two different forms (whether on the same computer or on a different machine) and both attempt to make changes. Is there a way (preferably simple) to just LOCK a record in a particular table to keep this from happening? I assume there has to be, but I've just never taken the time to find out. I'm not sure if this locking is done on the form level or somewhere in a table option or something.
 
Type "Lock" into Access help and then read "RecordLocks Property". This should explain Record Locking for you.
 

Users who are viewing this thread

Back
Top Bottom