Stack Overflow for Teams A private, secure home for your team’s questions and answers. M9 1a8 8 0 1 0 0 16A8 8 0 0 0 9 1zm. Overflow to have all the answers! Otherwise, the autocompact shall by default be set to true binary option robot setoption each main module of an Access app.
In case of a disaster, create a new mdb file and import all objects from the buggy file. I have compact on close set, but might have to review that. Had a moment where it hung while compacting yesterday, killed the process and wondered if it had corrupted my db. Sighed in relief as I realised it compacts to a temp file, but still. I was talking of temporary tables, not temporary databases. THe very best option, for temp tables, is to avoid them.
Try adding this module, pretty simple, just launches Access, opens the database, sets the “Compact on Close” option to “True”, then quits. 1GB this can be rather annoying when you go into it directly and it takes 2 minutes to quit! EDIT: added option to recurse through all folders, I run this nightly to keep databases down to a minimum. Code is provided without warranty and can be stolen and amended as required. Yes it is simple to do. I guess the difference between my version and yours is that this answer appears to be for Access 2007 and mine for Access 2003 and lower.