Many customers have 100's of temporary tables filling up their MDB.
many of these tables have the following naming patterns:
R0?????
R0?????_M
RPTMP_????????_0?
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.