R
Ron In Tulsa
I have a relatively small Access 2000 database with the main table currently
containing only 103 records. The database and application reside in one mdb
file on a network server. The application has a main process that loops
through the main table and performs simple calculations. I am using ADO.
The process takes under one second to complete as long as I have not opened
any of the reports that are based on the table being processed. If I run any
of the reports or even open them in design mode and then close them, the
processing time for running the process jumps to over 15 seconds. I have
tried exporting all my tables, queries, forms and modules to a new database
and that didn't solve the problem. I tried creating an mde file and that
didn't solve the problem. I'm stumped. The reports in question have no
modules. Thanks in advance.
containing only 103 records. The database and application reside in one mdb
file on a network server. The application has a main process that loops
through the main table and performs simple calculations. I am using ADO.
The process takes under one second to complete as long as I have not opened
any of the reports that are based on the table being processed. If I run any
of the reports or even open them in design mode and then close them, the
processing time for running the process jumps to over 15 seconds. I have
tried exporting all my tables, queries, forms and modules to a new database
and that didn't solve the problem. I tried creating an mde file and that
didn't solve the problem. I'm stumped. The reports in question have no
modules. Thanks in advance.