Bloating

[Mr. Bud]

Hi and TIA! I have a frontend/backend configuration with around 20 to 30
users at any one time. The backend has no queries/forms/code/temp tables
etc. only tables to store my data. It starts out at around 8mb after a
fresh compact/repair. After just a day or 2 it bloats to around 45mb.
Between that time probably only around a 100 or so records have been added
to my main table in the backend which contains 30 fields. Most are text
fields set to the size required and most are only 1 to 5 chars long. No
images, a couple date fields and 1 memo field which is normally only 50 to
100 chars and usually much less. Using A2002 - 2003 file format. Is this
normal? If not any idea what's causing it and/or how to prevent it. Also,
in frontend I'm using DAO recordsets but always close and set db and rs to
nothing. Thanks for you time.

 

[Roger Carlson]

If, after a second day of use, it grows to 90MB, then you have a bloating
problem. But if it stays about that size or grows slowly after that, then
45 MB is probably the right size for it. The compacted size in not
necessarily the size a database "should" be. It is the size with all the
empty records and workspace removed. In the course of using the database,
however, Access creates working space that is reused.

 

[Mr. Bud]

Roger thanks. Like I was saying for the most part (99%) of the time records
are only added to the BE and its really only a couple hundred or so over a
few days. The records are then queried/edited etc. from the FE with all the
processing taking place on the frontend. Are you saying that manipulating
records via the FE cause the BE access db to create workspace in the BE?
Thanks again for your time.
--

Reggie

If, after a second day of use, it grows to 90MB, then you have a bloating
problem. But if it stays about that size or grows slowly after that, then
45 MB is probably the right size for it. The compacted size in not
necessarily the size a database "should" be. It is the size with all the
empty records and workspace removed. In the course of using the database,
however, Access creates working space that is reused.


--
--Roger Carlson
MS Access MVP
www.rogersaccesslibrary.com
http://rogersaccessblog.blogspot.com/