I work with an online ordering system that uses an Access front end and a SQL Server backend. My predecessor set up our sales report based on a Sub-Procedure. It is my inderstanding that using sub-procedures is faster because it runs within the SQL server, though sometimes not the first time it is run. This report is taking 30 seconds to a minute to run every time it is accessed. Does anyone have any suggestions?
Report Taking Too Long
- Thread starter MATAdmin
- Start date
