CODEWITHSUNDEEP
sqlms-accessjetrowlocking
CJ7
CJ7

Reputation: 23285

Can you do row locking in Access?

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

Upvotes: 2

Views: 3800

Answers (3)

phadaphunk
phadaphunk

Reputation: 13313

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.

Upvotes: 1

Nigel B
Nigel B

Reputation: 3597

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

Upvotes: 1

LittleBobbyTables - Au Revoir
LittleBobbyTables - Au Revoir

Reputation: 32710

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.

Upvotes: 0

Related Questions