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