Compact and Repair Access DB using macro

[karlomutschler]

good day,
is it possible to compact and repair an Access DB using a Macro inside the DB ?

Any useful tips would be highly appreciated.

Kind regards
Karlo

meistertools@gmx.net

 

[Remou]

Hi
This may be useful:
Compact and Repair automatically at the start of each day
faq705-4998

 

[n3buo]

Here the code I use to compact and repair:

'Public Sub CompactDB()
CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database utilities"). _
Controls("Compact and repair database..."). _
accDoDefaultAction
' End Sub


I hope this helps

 

[mp9]

So you don't even have to remember to open the database each day...

http://www22.brinkster.com/accessory/resources/001.shtml