automating decompile / recompile in ms-access

my front end fr开发者_开发知识库om time to time is getting larger. i am building new reports and forms.

i know that remou suggests to decompile and compile every so often to make sure nothing is corrupt. can i automate this decompile/ recompile process?

What kind of automation do you have in mind?

Edit: If you intend to automate this, don't automate decompile in isolation; include backup and compact with decompile.

You could try something like this as one line in a BAT file, changing the paths to match your version of msaccess.exe and your database file:

"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

Danny Lesandrini discussed other options for decompile and other maintenance type stuff in a Database Journal article: Microsoft Access File Backup and Maintenance Options

I think he mentioned the method I use ... a decompile context menu option in Windows Explorer. You can find more information including a REG file at Getting the Decompile and Compact context menu options