A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  


Thread Tools Display Modes
Old April 12th, 2010, 05:46 PM posted to microsoft.public.access.gettingstarted
Mr. Bud
external usenet poster
Posts: 11
Default Bloating

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.




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 10:12 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.