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

Christopher Hawkins clh at christopherhawkins.com
Sun Jul 10 22:01:26 CDT 2005


"The actual setting on an object will override this. What you specify on the Form is what you get."

I had a feeling.  ;)

-C-

----------------------------------------
 From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
Sent: Sunday, July 10, 2005 2:27 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list