Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  X locks on the SQL table

Author  Topic  CanadaDBA 583 Posts Posted - 2005-08-31 : 11:31:07 I have posted this on Administration and someone tipped me to post it here. Environment: Access 2003 Sp1 SQL Server 2000 8.00.818 SP3 Windows 2003 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? The code was working until last week that we deployed 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 appends, there should be a command from Access to SQL Server that update the indexes and unlock the table but this doesn't happen. Canada DBA