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.

--

Reggie