MS Access holds locks on table rows indefinitely

I didn't solve this problem, but a colleague did. What was done is that instead of creating linked tables to SQL Server tables he created linked tables to views. The views looked like this:

CREATE VIEW dbo.acc_tblMyTable
AS
  SELECT * FROM tblMyTable WITH (NOLOCK)

No locking, and as a bonus Access treated the data as read-only.

Make sure you understand what can happen when you use NOLOCK, however.

Unfortunately MS Access is not part of my skill set so I don't know what needs to be done to fix this.

Get rid of Access :)