Make Table Query - setting Table properties?

[Fizzio]

This is Db specific

It is set for the particular Db, not by PC, so if you set it on your Db, this will be apply for every PC it runs on.

 

[Damonpc]

Whilst this code does not do it automatically on close it could be called from your closing code.

I have it run from a button on the switchboard.

Hope it helps.

Option Compare Database


Sub Compacts()
CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database utilities"). _
Controls("Compact and repair database..."). _
accDoDefaultAction

End Sub

Damon