Reporter Cleanup.docx

File uploaded by Gordonn_Lamothe Employee on Oct 19, 2015
Version 1Show Document
  • View in full screen mode

Many customers have 100's of temporary tables filling up their MDB.


many of these tables have the following naming patterns:





These are all Reporter and Reporter Results tables.


Too many of these can cause Space and Performance issues.


The attached Document has 2 Queries:


1. Lists all the Reporter Results for all you Reports


2. Allows User to Delete All Reporter results over X number of days


This should in turn clean up a lot of the Reporter temp tables.