How To Implement A Successful Exclusive Lock on an Access Table

dim rsSld as dao.recordset

set rsSld = DbSupmCon.openRecordset("TABLENAME",dbOpenTable, dbDenyWrite+dbDenyRead)

I am not achieving the nanosecond exclusivity I am after. Why Not.
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.

Jeffrey CoachmanMIS LiasonCommented:
Please explain, in terms that normal Access developers can understand, what this unknown term: "nanosecond exclusivity" means please.

I Googled it, and found no references to it, meaning:
It is a "Made up" term
It does not exist.
It is too esoteric
It is not widely used



Simply opening a recordset this way does not, as I understand it, enforce exclusive use.
It only becomes exclusive when you use it.

Like Jeff, i don't know what you mean by  "nanosecond exclusivity".
Jeffrey CoachmanMIS LiasonCommented:
Try this:
set rsSld = DbSupmCon.openRecordset("TABLENAME", dbOpenSnapshot, dbReadOnly)
The Ultimate Tool Kit for Technolgy Solution Provi

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 for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Jeffrey CoachmanMIS LiasonCommented:
Isn't this is basically a duplicate of:

If not, can you explain the difference?
NolancAuthor Commented:
The solution to my problem is provided by searching the Microsoft Knowledge Base for the title "How to create a Multiuser Custom Counter - Article ID: Q140908"

I will be closing the question and thank you all for your participation.

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
Jeffrey CoachmanMIS LiasonCommented:
Great, congratulations

(I am still interested in knowing what you meant by "nanosecond exclusivity", though)
Jeffrey CoachmanMIS LiasonCommented:

Thanks, but my post was not meant to be a solution, hence you did not have to accept it.

It seems that you have solved your own issue in post:24472645,

I have requested that this Q be re-opened so that you can accept your own post as the solution.


NolancAuthor Commented:
I assume it takes a NanoSecond to execute the following statements.

rsSld!SldNumber = TxtRef.Text

I wanted Exclusive Use of The recordset before doing this.
Hence my "Nanosecond Exclusivity" request. I trust that you are impressed with my "self-Invented" phrase. Thanks again for your help.
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.