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:

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.

Attachments

Outcomes