ADP VERY SLOW WITH SUBFORMS HELP!
Does anyone know why an .ADP report with three subreports would take over two minutes to load??? I've got 3 more subforms to add and I'm afraid the report will be unusable.
Two of the subforms are views linked by master child relationship.
One of the subforms is a stored procedure using input parameters.
There's not that much data to filter in either the views or the sp (500 records is the largest view)
The there are 4 input parameters on the sp, two being supplied by an open form and two by the main report.
Yesterday, the thing was still trying to load after 15 minutes before I stopped it. Today, it's loading in about 2 and a half.
I'm using Access 2003 connected to SQL 2000 Desktop Engine. I'm on a stand alone machine.
Any help would be greatly appreciated.