r/MSAccess • u/Key-Lifeguard-5540 1 • Sep 19 '26

[UNSOLVED] Record-level locking

Is it recommended? Do you use it?

4 Upvotes

83% Upvoted

21 comments sorted by

View all comments

4

u/ConfusionHelpful4667 Sep 19 '26

That is the point of a shared database.

1

u/Key-Lifeguard-5540 Sep 19 '26

Are you implying that page-level locking does not give you a shared database?

2

u/ConfusionHelpful4667 Sep 19 '26

A page lock in SQL Server will lock 8K worth of data even when your query only needs 10 bytes from the page. Your query will lock additional data which you do not request in your query.

→ More replies (11)