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

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.