How To Implement A Successful  Exclusive Lock on an Access Table

Posted on 2009-05-25
Medium Priority
Last Modified: 2013-11-29
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.
Question by:Nolanc
  • 5
  • 2
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24467950
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



LVL 77

Expert Comment

ID: 24467968
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".
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24468022
Try this:
set rsSld = DbSupmCon.openRecordset("TABLENAME", dbOpenSnapshot, dbReadOnly)
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24468048
Isn't this is basically a duplicate of:


If not, can you explain the difference?

Accepted Solution

Nolanc earned 0 total points
ID: 24472645
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.
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24474584
Great, congratulations

(I am still interested in knowing what you meant by "nanosecond exclusivity", though)
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24483779

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.



Author Closing Comment

ID: 31585063
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.

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

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.

Join & Write a Comment

Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question