I am trying to Compact Database on Every 5th closing with the help of the following link but have failed to do so.
http://datapigtechnologies.com/flash...ctonclose.html
I am having a problem with the following Function. I presume the following code is for access 2000 whereas I am using access 2007
Function CompactFunction ()
CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database utilities"). _
Controls("Compact and repair database..."). _
accDoDefaultAction
End Function