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

Stuart McLachlan stuart at lexacorp.com.pg
Sun Jul 10 15:24:46 CDT 2005


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





More information about the AccessD mailing list