MS Access 2003 Record Locks settings

I have a an Access 2003 DB and set to record level locking  for edited records.  I also see that a form has record locking in the properties.  What is the difference?  Does one over ride the other?  If I see the form to no locks but have advance settings of the DB set to Edit record lock what happens?

Thank you.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
The form properties control when the lock is placed.

"no locking" means no edit lock, or optimistic locking - lock is only placed when the record is updated.
"edited locks" are pessimistic locking - record is locked for the entire edit.

and record level locking does not work unless you open a ADO connection first.  DAO was never updated for record level locking. See:

PRB: Jet 4.0 Row-Level Locking Is Not Available with DAO 3.60

thandelAuthor Commented:
OK thanks but how does changing the advance settings for record lock differ that changing the form record settings?
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Let's get specific; what form properties are you talking about?

Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

thandelAuthor Commented:
Under Tools | Options | advance there are record locking options..... there are also record locking option under a given form's properties.   Data | Records Locks | (Edited record, all records, no locks)

I am wondering how to these two setting locations interact.  For Example if I have the DB advance option set to Edit record but then the forms option set to no locks.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
OK, just wanted to make sure what we were referring to.

 Where the settings are duplicated, it's what the form specifies that is in effect.   The advanced options are defaults for new form creation.

 But the one setting in advanced that does play a roll is record level vs page locking.  That is not duplicated in forms.  This setting says at what level a locked will be placed.  The form setting tells us the type of lock (when it will get placed).

Once exception however is that you can specify "All records" in the form, in which case, you are modifying the level it gets placed at.

 and not to make it thoroughly confusing, but some operations (ie. an index update) are done at the page level no matter what the settings specified.

 Record level locking was an add-on, and not done very well.

 Does that all make sense?


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
thandelAuthor Commented:
Ah as a default for a new form... didn't realize.. good to know and thanks for the other info... makes sense (or at least clarifies my question)  :)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.