title: MS Access Locks Tables in SQL Server?
body: <p>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?</p>