S Scott Oct 8, 2004 #1 I want to create a macro that upon closing the database will automatically compact the database. Can anyone help? Thanks!
I want to create a macro that upon closing the database will automatically compact the database. Can anyone help? Thanks!
N Nikos Yannacopoulos Oct 8, 2004 #2 Scott, If you have Access 2000 or later, you don't need a macro for that, it's a built-in feature! All you need to do is go Tools > Options, select tab General and tick Compact On Close. HTH, Nikos
Scott, If you have Access 2000 or later, you don't need a macro for that, it's a built-in feature! All you need to do is go Tools > Options, select tab General and tick Compact On Close. HTH, Nikos
