I have a client who is using SQL Server as the backend to an Access database ... for some reason everytime a user opens a form to make changes, Access puts a lock on the table and does not release it ... preventing anybody else from making modifications to ANY records. I have yet to find a solution. All users are using the same front end, so I suggested making multiple copies of the front end, but they are hesitant to do that.
My question is, is it possible to write a script that runs every so often to remove all open locks? I know that could be dangerous, but for now, it's a possible work around.
dbageek - Shaun Beane
Instructor/Developer
My question is, is it possible to write a script that runs every so often to remove all open locks? I know that could be dangerous, but for now, it's a possible work around.
dbageek - Shaun Beane
Instructor/Developer