WeaponX

Try this and see if it does any good.

DG
---------------------- Forwarded by Darron C Giron/HOU/ECT on 10/17/2000
10:17 AM ---------------------------

Greg Couch
10/13/2000 10:43 AM
To: Jeffrey C Gossett/HOU/ECT@ECT, Kyle Etter/HOU/ECT@ECT, William
Kelly/HOU/ECT@ECT, David Baumbach/HOU/ECT@ECT, Darron C Giron/HOU/ECT@ECT,
Kam Keiser/HOU/ECT@ECT
cc:
Subject: WeaponX

I would like each of your book admins using WeaponX to begin using the
following procedures at least once/week (if they aren't already).

Open the database while holding down on the shift key. This will open the
database, but prevent the main form from opening automatically. Next, the
admin should go to Access menu selections and choose Tools/Database
Utilities/Compact Database. After the database has completed compacting, you
can use the database as normal.

Just a quick explanation:

This is standard procedure for Access databases. WeaponX imports and deletes
a lot of data on a daily basis. When data is deleted, the space is not freed
up that was used by the data. Therefore, as time goes by, the database size
grows and grows and needs to be periodically compacted.

The Texas WeaponX file that I compacted reduced from 520 MB to 30 MB and one
for the west went from 400 MB to 12 MB. You can see that we will save
several GB if everyone begins compacting the databases on a regular basis.

Please note: Even though this is standard Access procedure, I would
recommend that the book admin save a copy of their existing WeaponX file
prior to compacting for the first time. Once the file is compacted and a
daily run has been successful, they can delete the backup file. It is not
necessary for them to save a backup copy each time before compacting. I am
only recommending it for the first compact.

I don't anticipate any problems with this procedure. As a matter of fact,
Crystal (East desk I believe) already compacts the database on a daily
basis. In addition Ann (West desk) ran a test for me with no problems.

Please let me know if you have any questions.

Greg