Some reports open really slow, sometimes.

[joejack0330]

Having some issues with Access .adp and sql server 2005. A couple reports with stored procedures as data source open really slow or timeout somemtimes yet when run that sp direct in SQL, it always runs quick. It's alays a little slower to open in Access but when it's cached, it seems to run pretty quick in Access which makes sense but always seems pretty good in SQL server itself. Any suggestions as to where to look? Thanks, Joe

 

[ajrimmer]

Are you using Access 2007? If yes, then installing SP2 could help.