JohnHarkins
MIS
I have a lengthy, but seemingly not complicated report that consists of name, address, phone number(s), e-mail address(es), the latter two of which are handled each with a sub-report. The report does work, but performance is very poor. In fact, it's so poor that I experienced a real oddity: the report ran for hours and then returned me to the main Access database screen (all items just as before I ran the report). No report, no nothing.
Since I had each phone number and address subreport being controlled by a query (I wanted not to see "inactive" entries), I created two temporary tables with the appropriately pre-selected records (i.e., only active records), then pointed the sub-reports to their respective temporary tables and then ran the main report. All was well, if not, at least it was better, except that the report previewed satisfactorily with a missing mouse pointer whenever I moved the mouse over the Access 2000 database window. The mouse was active in that I was able to estimate where the mouse was positioned and click on an item successfully (talk about dancing in the dark!). When I moved the mouse over the toolbar, I could see the appropriate items highlighted.
I'd like to solve the performance problem for sure. That is, I want not to have to create temporary tables and I'd be delighted to improve the speed of creating the report at the same time. Performance does seem to be a function of how many items are in the phone number table compared to the number in the e-mail address table (a ratio of some 25 to 1). And, of course, I'd like to get back my cursor which doesn't return until I exit from Access and restart Access.
I've searched the web, checked the knowledgebase, run the report on a smaller RAM-configured machine (48MB instead of 128MB), but no joy.
Any good ideas? In fact, any ideas?
Thanks,
John Harkins
Since I had each phone number and address subreport being controlled by a query (I wanted not to see "inactive" entries), I created two temporary tables with the appropriately pre-selected records (i.e., only active records), then pointed the sub-reports to their respective temporary tables and then ran the main report. All was well, if not, at least it was better, except that the report previewed satisfactorily with a missing mouse pointer whenever I moved the mouse over the Access 2000 database window. The mouse was active in that I was able to estimate where the mouse was positioned and click on an item successfully (talk about dancing in the dark!). When I moved the mouse over the toolbar, I could see the appropriate items highlighted.
I'd like to solve the performance problem for sure. That is, I want not to have to create temporary tables and I'd be delighted to improve the speed of creating the report at the same time. Performance does seem to be a function of how many items are in the phone number table compared to the number in the e-mail address table (a ratio of some 25 to 1). And, of course, I'd like to get back my cursor which doesn't return until I exit from Access and restart Access.
I've searched the web, checked the knowledgebase, run the report on a smaller RAM-configured machine (48MB instead of 128MB), but no joy.
Any good ideas? In fact, any ideas?
Thanks,
John Harkins