Hi Experts!! SQL Server 2008 R2 - Access 2003 Front-end (I know, I know) ... I just picked up a client... many, many, users... an application in production and in need of some major reconstruction and upgrading --- I am looking for advice.
They are getting locked out daily -- Record Locking and Time out errors -- as I'm very new to their situation I wanted to get some guidance on best practices. I checked... all the SQL tables have a timestamp field and all bit fields are set to not allow nulls with a default value of 0. Huge number of records... too many indexes... Want to work as efficiently as possible to resolve this issue before I tackle some of the other issues -- and before I tell them they need to upgrade to a newer version. of Office/Access.
I wrote some SQL queries (to utilize the sp_lock) but since most users are gone, all have GRANT access -- will run that when they get hit tomorrow...
As always -- thanks in advance for any direction.