November 12, 2010 at 12:12 pm
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
November 12, 2010 at 2:44 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply