Recent content by moconnell2007

Thanks SQL Hell for the suggestion. The .CommandTimeout = 0 didn't make a difference - had tried this already. I did manage to track down the issue tho. Inside the SP, DTS packages and user defined functions were being called - which was fine. However, within some of these were print stmts...

Hi All, I have inherited an MS Access application recently. I have a problem with a call to a SQL Server stored procedure (from VBA in Access). The connection is established with ADO and connects to the server fine and starts running the SP. However, there is a loop in the SP (while...