[AccessD] DB-level Edited Record vs. Form-level No Lock - who wins?

On 10 Jul 2005 at 14:08, Christopher Hawkins wrote:

> First, the technical:
> 
> Tools > Options > Advanced > Default Record Locking.  So, I went ahead and set that to Edited
> 
......
> Here is what I am curious about:  in a case where the DB-level settings specify Edited Record
> locks and the forms themselves specify No Locks, which setting wins?  I've been poring over
> support.microsoft.com but have found no answers to this question so far.

Note the word "Default" under Tools-Options.... it's just that - a default 
so that you don't have to set it  on every object if you generally want the 
same setting.  The actual setting on an object will override this. What you 
specify on the Form is what you get.



-- 
Stuart