[Modus] For those of you not using SQL, we created a VB Script to compress Mailstore.mdb, on a daily basis..

[Daniel Nerenberg]

Just a quick Update as to what is new in the “Vircom” version of the script:   The script we wrote actually generates the script you will need to compact the Access MDB file. It reads the path to the quarantine file out of the registry, and it can even schedule the script to run at a specified time.   All the functions are performed from one “compact.vbs” file. The file updates the application event log when it runs properly.   If you would like to try out the script e-mail [EMAIL PROTECTED]   Also Thanks to Don for the initial research!   Daniel Nerenberg 514-845-8474 www.vircom.com [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Button Sent: Friday, December 05, 2003 8:32 AM To: [EMAIL PROTECTED]; 'Customer Support' Subject: [Modus] For those of you not using SQL, we created a VB Script to compress Mailstore.mdb, on a daily basis..   We have modified the VB script to compress the quarantine.mdb store.  If you are interested in ‘testing’ this script, please email [EMAIL PROTECTED].  We will be happy to send you the script.  After tests are completed and successful, we will make the script available to all customers (using Access DB).   Regards,   p.s. Thank Don.       Robert Button Director, Customer Services Vircom Inc. www.vircom.com     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Van Oort Sent: Wednesday, December 03, 2003 9:58 AM To: Customer Support; [EMAIL PROTECTED] Subject: [Modus] For those of you not using SQL, we created a VB Script to compress Mailstore.mdb, on a daily basis..   Just wanted you to know that we have resolved the issue with the access DB for Sieve data, growing & growing.   We created a batchfile to stop the ADM service, call a VB Script to compact the DB, and then restart the service.   I created an AT command and scheduled this to run nightly at 3:00am. on our server and it seems to be working nicely.   The problem (as I understand it) is that a Microsoft Access database is used to store the index information for all Spam you receive.  Apparently MS Access does not recover space in the database as messages are deleted from Quarantine.  So what happens is that this MS Access Database (mailstore.mdb) grows and grows until your MM server slow’s to a crawl as ours has done many times.   To correct the problem you either stop the MM Administration service, and delete the mailstore.mdb (which causes everyone to loose everything in their quarantine I think).  Or you can stop the service, open the DB in microsoft access, and then select tools – compress database.   Problem with these methods is that they require direct intervention (labor).   Script we created resolves this by allowing this compression to happen automatically each night (or whenever you schedule it to happen).   If you want to use this code you are welcome to it.   The code needs to be modified slightly to reflect the MM installation drive for each specific installation but it works great and does not require MS Access to be installed on the MM server.   Couple words of wisdom:   1. before installing this, verify that you have room (disk space) as this will require slack space at least equal to the size of your mailstore.mdb file.   2. notes about this are included in the compact.bat  batchfile   Works for us but use at your own risk.     Thanks.   <don   Don Van Oort President R & D Industries, Inc.