UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Global Vs Form-based Record Locking, Access 2010    
 
   
dwilson
post Mar 10 2018, 01:05 PM
Post#1



Posts: 64
Joined: 10-October 17



I've seen some posts saying that one major cause of back end bloat is having the client-level "open databases by using record-level locking" setting turned on. My question is this: can I assume that this setting is redundant in a multi-user environment if the form-level property for record locks is set to "edited record?" In other words, for the purpose of avoiding multi-user conflicts on a specific form, are these two settings equivalent? And what happens if the same record is simultaneously being edited in two different forms? If both forms have the local property set to edited record, but the forms themselves are not the same, with one recognize that the record is locked by the other?
Go to the top of the page
 
ranman256
post Mar 13 2018, 09:54 AM
Post#2



Posts: 867
Joined: 25-April 14



i never set them.
what are the odds of 2 people editing the same record at the same time? Editing.
Go to the top of the page
 
dwilson
post Mar 13 2018, 11:08 AM
Post#3



Posts: 64
Joined: 10-October 17



In my application, the odds of two people trying to edit the same record at the same time are very high. In fact, it's almost guaranteed to happen several times per day.
This post has been edited by dwilson: Mar 13 2018, 11:09 AM
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    22nd July 2018 - 04:12 AM