Forum Discussion
MS Access passthrough query performs very slow when executing a stored procedure
I have a passthrough query in my Access frontend that I use to import data from a sql server db. I work with MS 365 MSO Version 2302 32 Bit. Before executing the passthrough query I pass the connecti...
Show us the entire procedure, not just this snippet, please.
The error occurs on the statement Set rstDAO = qdf.OpenRecordset. But the timeout occurs also when executing the PT query manually, so I don't think the VBA Code is relevant. The exact same EXEC statement is executed without problems in SSMS with the same user.