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.