L
LeAnn
I'm not sure if anyone can help me but I would like to speed up the output of
my report. I have a stand alone Access 2003 database located on our file
server (no front-end/back-end). The report is based on a union query but
there are a series of other queries that must run before the report is
generated. I am querying an Oracle system (located across town) and a
FoxPro database (NT4 server located here).
I have:
4 pass through queries (2 for each system above)
4 make-table queries 1 for each of the pass throughs
2 select queries that each use 2 of the above tables
and finally, there is a union query that returns all of the records from
the 2 queries above.
The report has VBA to hide or display records and was taking 60 - 90 seconds
to export (when each of the make table queries returned about 1500 records).
Unfortunately I had to remove some of the selection criteria and now 2 of the
queries are returning 20K+ records. The selection criteria is now stored in
a local table and that was added to my "lookup" queries to select records
using a left join. Now the report takes 3 - 4 minutes to export.
Some of the problem could be the server and network speed but is there
anything I could do to speed the query processing? I can't index any fields.
Hope this makes sense to someone.
Thanks
LeAnn
my report. I have a stand alone Access 2003 database located on our file
server (no front-end/back-end). The report is based on a union query but
there are a series of other queries that must run before the report is
generated. I am querying an Oracle system (located across town) and a
FoxPro database (NT4 server located here).
I have:
4 pass through queries (2 for each system above)
4 make-table queries 1 for each of the pass throughs
2 select queries that each use 2 of the above tables
and finally, there is a union query that returns all of the records from
the 2 queries above.
The report has VBA to hide or display records and was taking 60 - 90 seconds
to export (when each of the make table queries returned about 1500 records).
Unfortunately I had to remove some of the selection criteria and now 2 of the
queries are returning 20K+ records. The selection criteria is now stored in
a local table and that was added to my "lookup" queries to select records
using a left join. Now the report takes 3 - 4 minutes to export.
Some of the problem could be the server and network speed but is there
anything I could do to speed the query processing? I can't index any fields.
Hope this makes sense to someone.
Thanks
LeAnn