DB Grows.

  • Thread starter Thread starter Jarryd
  • Start date Start date
J

Jarryd

Hello,

Does anyone know why an Access DB grows so much and you have to run the
compact/repair tool every day to keep the file size down?

TIA,

Jarryd
 
No, it is just a basic DB for storing text data, i.e. amounts, addresses,
telephone numbers. If I do compact/repair it shrinks to about 680KB. If I
update any of the VBA or make any changes to the schema it grows in leaps
and bounds. If I just add orders or some details to a cutomers record it
goes up less bu still more than it should. By running compact it goes back
to 68KB again. Why?

TIA,

Jarryd
 
Do you compile your database after you make changes to the VBA? You might
try the decompile switch also. Here are the steps.

1. Make a backup of your database.
2. Open database using this command line -- "FullPathToMSAccess.exe"
"FullPathToDatabase.mdb" /decompile.
3. Hold the shift key down until the database is fully opened.
4. Compile Database
5. Compact Database


--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html
 
Back
Top