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

John W. Colby jwcolby at colbyconsulting.com
Mon Jul 11 06:23:39 CDT 2005


Default usually means that as you start to desing an object, that is what
that property will start as.  If you change it during design, then it ends
up different.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Christopher
Hawkins
Sent: Sunday, July 10, 2005 11:01 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] DB-level Edited Record vs. Form-level No Lock -
whowins?


"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


-- 
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