X locks on the SQL table | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

X locks on the SQL table

I have an Access query that appends some rows to a SQL Server table. The problem is that after the data is populated, there are X locks remaining on the SQL table and the developers can’t do anything while they are in there. If I kill the process, then they can continue. What’s the problem?
Access 2003 Sp1
SQL Server 2000 8.00.818 SP3
Windows 2003 CanadaDBA
I am not sure but what about if, Trying to populate data in temporary tables and move from there. Deepak Kumar –An eye for an eye and everyone shall be blind
The code was working until last week that we deploied a new compile of Access application.
The Access query is not changed. The problem is like if I want to append 100 records, a number of 100 (or more) X locks appears on the table in SQL server. By ending the appendings, there should be a command from Access to SQL Srever that update the indexes and unlock the table but this doesn’t happen. CanadaDBA