CODEWITHSUNDEEP
sql-serverms-accesstable-lockingtable-lock
PingPing
PingPing

Reputation: 999

MS Access Locks Tables in SQL Server?

I've been using SQL Server for 2+ years but I am new to MS Access. I have just started to look at MS Access as a potential front-end/portal to access SQL Server and I was talking with a colleague who said I should be wary of the potential for MS Access to lock an SQL table if my Forms aren't coded correctly. I've experienced table locks before and can appreciate how frustrating they can be. My colleague mentioned using something called a 'pass-through' to get over the problem. Can anyone please help me by explaining what is happening and how a 'pass-through' solves the problem?

Upvotes: 0

Views: 4729

Answers (1)

Tamas
Tamas

Reputation: 39

Regarding SQL pass-through queries in MS Access please see the following link - it explains how to create such a query...although this is related to Access database rather MS-SQL... How to create SQL pass-through query in Ms Access

Apparently you can control Access locking mechanism (in 2013 version at least) by opening the Property sheet of the Form in Design mode, move to Data section and there will be one entry called "Record Locks" with 3 options as "no lock", "all records" and "edited record" (this sounds like a row-level lock). I have never tried them in action, but that option is probably dedicated to manage Access locks on linked tables.

Upvotes: 0

Related Questions