We have a Access database we use for logging tasks in our schedule (developed internally but not by me - I'm networking & OS not a DB engineer).
This was first written under 2003 and we have recently had to make certain changes so it will work under 2007.
It seems to work fine but we are experiencing a 'bloating' issue. The DB is about 20-25Mb after a compact & repair but if left to its own devices it can grow significantly in just a few days (to the order of a half gigabyte!)
I am aware of "Compact on close" but the DB will usually be open by a minimum of 10-15 users at any one time, sometimes as many as 50 and i'd have to kick each and every one of them out to do this (and ensure that other don't open it in the meantime!)
Can anyone provide any ideas as to what may be causing this? Is it a potential bug in 2007, do we have a bug in the code of the DB etc etc