mdb File size

  • Thread starter Thread starter Burt Rosner
  • Start date Start date
B

Burt Rosner

Dear Sir/Madam,

I'm developing a program, that although not very
sophisticated, it is very intricate. I notice that as I'm
developing and running the program (in MSAccess 2002 on
Windows 2000 Pro). The file starts getting larger (e.g.
goes from 10 meg to 99meg). When I do a "Compact and
Repair Database" the size drops to 10meg. I tried to
incorporate the "Compact and Repair Databaase" function
into my program, but get a message saying I can't do that.

Is there a way I can control the size of the file in the
backgroumd without always doing a "Compact and Repair
Databaase".

Thanks in advance for your help,

Burt
 
Further to whatDouglas said: database "bloating" often results from
performing certain actions such as, repeatedly creating & deleting tables.
If you are doing such things, you may be able to stop the bloat by doing
those things in different ways. Google on "database bloat" (or similar) &
you will doubtless find some more information.

HTH,
TC
 
Back
Top