We have a commercial accounting software package programmed in Access. Recently began having to wait for some reports to process to the screen for over 3 minutes. We have only had this software for under a year and have eliminated the problem being the network by moving the data files from the server to the desktop and running the reports there - no difference.
Developer tells me that the only changes they've made to the structure of the reports is to make them "SQL Server ready" for future use. Could this change cause the sudden slowing of report processing?
We are now looking at upgrading our workstations of course, but I'm wondering why this problem just suddenly showed up instead of a gradual slowing down over time as the amount of data in the tables increase?
March 30, 2005 10:28 AM
March 31, 2005 9:13 PM