MS Access Query Locking up MSSQL 2000 SP4

• Luk - ARG

  SSChasing Mays

  Points: 621

  More actions

  November 12, 2010 at 12:12 pm

  #388220

  Hi everyone, I've been 2 days straight cracking up my head trying to fix an issue, here it is, let see if somebody can help me out:

  - MSSQL 2000 SP4

  - MS Access 2003

  User has an Access Form that querys data from the SQL Server and makes an update.

  Before running the SP that makes the update, it shows on screen a view, for some reason that view is causing a block that doesn't let the SP run, so after a while the MS Access gets disconnected due to a Time Out.

  The query on the view is a very simple query:

  SELECT ItemNumb, KitID, BarCodeValue, LinkValue, QtyRequired, WorkOrdNumb, QtyScanned, Status, BarCoded, Descrip, SeqNumb FROM vwDetailReadyForScan where WorkOrdNumb = '" & Me!vWorkOrder & "' and MatType = 'FG' order by SeqNumb

  User has select privileges on the view.

  Any idea on what could be causing this query to lock the SQL?

  Thanks

  Luk

• Luk - ARG

  SSChasing Mays

  Points: 621

  More actions

  November 12, 2010 at 2:44 pm

  #1250266

  This has been fixed, this topic can be closed or removed. (I didn't find the option on how to do it myself)

  Thanks

  Luk