DB Grows.

[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

 

[Lynn Trapp]

Are you storing any pictures in the 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

 

[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

 

[Lynn Trapp]

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