[AccessD] Keeping your db in tiptop shape

Don't know if it helps at all, but below is a typical report that is emailed
to me following the overnight rebuilds.

You will see that it reports back the old size and the new size as well as
some other stuff.  This allows me to "verify" that the BE is "visually" the
size expected.  Not quite a "validation" in the true sense but instantly
alerts me to problems.

Max

15/04/2009 01:25:18 - pfGetEmailAddresses-OK
15/04/2009 01:25:18 - pfEmailByCDO-Start
15/04/2009 01:25:20 - pfEmailByCDO-OK
15/04/2009 01:25:20 - pfCompactRepairBE-Start
15/04/2009 01:30:09 - Wed  -  Repair and Compact of z:\Data\MCM_BEndA3K.mdb
ran  successfully 

Old Size 806,948kb
New Size 799,668kb
Reduction Of 7,280kb


15/04/2009 01:30:09 - pfCompactRepairBE-OK
15/04/2009 01:30:09 - pfRebuildWebPeopleTempTable-Start
15/04/2009 01:34:30 - pfRebuildWebPeopleTempTable-OK
15/04/2009 01:34:30 - pfPeopleWebPages-Start
15/04/2009 01:35:47 - pfPeopleWebPages-OK
15/04/2009 01:35:47 - pfOrgsWebPages-Start
15/04/2009 01:35:51 - pfOrgsWebPages-OK
15/04/2009 01:35:51 - pfBranchesWebPages-Start
15/04/2009 01:35:53 - pfBranchesWebPages-OK
15/04/2009 01:35:53 - pfRebuildWebBulbs2007TempTable-Start
15/04/2009 01:36:05 - pfRebuildWebBulbs2007TempTable-OK
15/04/2009 01:36:05 - pfBulbs2007WebPages-Start
15/04/2009 01:39:05 - pfBulbs2007WebPages-OK
15/04/2009 01:39:05 - pf_WWK_RebuildWorldWalkTempTable-Start
15/04/2009 01:39:05 - pf_WWK_RebuildWorldWalkTempTable-OK
15/04/2009 01:39:05 - pf_WWK_WebPages-Start
15/04/2009 01:39:05 - pf_WWK_WebPages-OK
15/04/2009 01:39:06 - pfRunUntilFinished - Run OK for
C:\AbyssWebserver\\htdocs\MasterIndexCopy.bat
15/04/2009 03:03:14 - pfRunUntilFinished - Run OK for
C:\AbyssWebserver\\htdocs\RunHTMLProtect.bat
15/04/2009 03:03:14 - pfGetEmailAddresses-OK
15/04/2009 03:03:14 - pfEmailByCDO-Start
15/04/2009 03:03:15 - pfEmailByCDO-OK