Thanks again. This will certainly work for the time being - I am putting the db onto a webserver (not my own) in the near future for users to access online - do you think this will cause any further size explosion problems (will your fix still work?)...

thanks cweiss

this has reduced the db to 14.5Mb but will this eliminate the problem for good? (or will I have to wait to find out!!)

Thanks for your help though. If anyone else know anymore about this db size explosion please help!

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...