I have created one database using ms access 2007. I save it today and its 2MB, I save it tomorrow and its 800KB... any ideas? Initially I thought it was because this depended on whether I had allowed the unknown macros content whilst re-opening the file, then saving it later on and noting the file size difference. The macros warning appears whilst opening my database, for my own files I usually allow, although I have now disabled the warning completely (top left of screen office button > access options > trust centre > trust centre settings > message bar > never show information about blocked content).
Can anyone tell me if this is related, or what the reason for the file size change is most likely to be? Whether it shows as 800kb or 2MB, the content is always identical, no data missing. Thanks for any help