Thread: Passthru with recorlocks
05-09-11, 11:53 #1Registered User
- Join Date
- Sep 2010
Unanswered: Passthru with recorlocks
Is it possible to have a passthru query in ms access lock records in sql server? I am trying this but without any results. I get no error msg's.
I am using WITH (HOLDLOCK), I also tried WITH (ROWLOCK). when i have another user try to query and make changes, they can make changes.