thanks for reading.
I got a problem which I have been suffering from for ages. we have a lot of MS access applications (Access '97) which link tables in sql server 2008. As you know the access application locks data extensively. And I can not use 'with nolock' table
hint in access application. the result is we have a lot of long locks or even deadlock. How to minimize the amount of locks?
Is there anyone who came across this issue and please share your ideas.
View Complete Post