unexplained filesize increase

[shelspa]

The size of my Access 97 database is increasing at a rate that exceeds what you would expect from just data entry. It will increase up to 40mg in only two weeks. After I compact it, the size goes down to around 9mg. I think it is related to opening and closing a data entry form. Doing this alone without even adding any data causes the database to increase in size by 12kb. What is up? If I can't solve this problem can I create a procedure to automatically compact the thing every time it is closed?

 

[psemianonymous]

Whenever you create & delete tables there is huge data bloat. Search Google (or Google Groups) for more specifics as to why.


There is no (good) way to automatically compact-on-close in Access97, and the situation is worsened by the fact that this feature is built into Access200--which means no one wrote a utility to implement this. At least I have not found one.


I'd recommend instead a formal backup and compact process, to be performed by one of the users either at the beginning or end of the work day. I know this isn't the answer you're looking for...


Maybe this will help: there is a way to programmatically compact the database:

runcommand acCmdCompactDatabase

I'm running an unpatched version of Access97, so your "acCmd" constant may differ slightly (i.e. accmdcompactandrepairdatabase).

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm