Can you do row locking in Access?

Question

Can you do row locking in Access/JET?

For example, can you do the following in JET SQL:

UPDATE Test WITH (ROWLOCK) 
SET UpdateDate = myDate 
WHERE PrimaryKey = myKey

Dont forget to mark this question as anwsered if it worked. – phadaphunk Aug 02 '12 at 16:19 — phadaphunk, Aug 02 '12 at 16:19

score 1 · Answer 1 · answered Jul 26 '12 at 13:02

1

As far as I'm aware you can only achieve this via the options and not in SQL Options->Advanced

answered Jul 26 '12 at 13:02

Nigel B

3,577
3
34
52

score 1 · Answer 2 · answered Jul 26 '12 at 13:02

1

From this article:

Open Access. Then click on Tools-->Options and select the "Advanced" tab.

There you'll find three options for setting Default Record Locks. You'll also find a check box labelled "Open databases using Record-Level Locking". Use "Help" to learn about what each of these options do for you and select the choices that you prefer for your databases.

answered Jul 26 '12 at 13:02

phadaphunk

12,785
15
73
107

@CraigJ Dont forget to mark this question as anwsered if it worked. – phadaphunk Aug 02 '12 at 16:19

score 0 · Answer 3 · answered Jul 26 '12 at 13:02

Access doesn't have query hints that I'm aware of.

It should be configurable at the database level. In Access 2003, for example, you can go to Tools > Options, go to the Advanced tab, and you'll find the Default record locking option, which gives you the following choices:

No locks
All records
Edited record

In addition, there is a Open databases using record-level locking checkbox below that.

Can you do row locking in Access?

3 Answers3