Can someone please help me! I have created a db in Access 2003 and the overall file size keeps doubling periodically. Before I noticed this phenomenon the DB was at 65Mb (could have been happening earlier). It then doubled to around 120Mb, then 241Mb and finally it was at 480Mb!! I had a back-up of the 65Mb version so I just copied the new tables/queries/forms from the latest db (480Mb) into the backup (65Mb) and it was OK for a while until it started doubling again. I tried to determine what was making it double by going through all the available actions etc but it seemed to be doing randomly! I have read on this forum something similar but the answer to that thread didnt help me.
I am a bit of a novice with DB's and i haven't split the db into Front-end and Back-end, but its quite small (around 20 tables but only 3 are of any real size, 25 queries, 20 reports, 8 modules (all performing mail-merge programmatically) and around 10 macros)
Does anyone have any idea why this is happening and how it can be prevented? I have been working on the db for months, with gradual additions to it as and when needed and so I would rather not have to start from scratch! (I am worried that my lack of db knowledge when i started may have meant i used bad practices - which is starting to manifest itself now!)