Increasing File Sizes

[MarkGallie]

I have an Access Database of around 8MB. However, after a day's use, this file size increases to around 110MB. If I run a Compact and Repair, the file returns to it's usual size. The first time I noticed this, the file had reached a size of 2GB which is a bit alarming. The file does get used but only appending around 50 records a day and making some amendments. What could be causing this increase?

Thanks

 

[pr2-eugin]

Hello MarkGallie, the file size to increase so dramatically for just 50 records is a suspicious..

* Has your table been properly Normalized? If not you might need to get your hands dirty right away..
* Does your table have any attachment/OLE fields? If so have you tried alternatives like Hyperlinks?
* Is your DB Split? If so, is this behavior on your Backend file or Frontend?
* Make sure that the Compact on Close option is enabled..

 

[MarkGallie]

I have enabled Compact on Close but this doesn't seem to have made a difference. The problem is that this file is literally just a database accessed by a number of other programs by Users and an Update Program running on a regular basis. Will I need to apply Compact on Close to these programs as well?

 

[pwbrown]

Do you use many temp tables?
I usually find this happens to me when using temp tables or using a delete and an append query on a table.
As stated by paul, compact on close option works fine for me.
I also try to have temp tables on another mdb.