my front end from 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?
+2
A:
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
HansUp
2010-07-26 20:27:23
Remou
2010-07-26 20:43:17
Right, that's why I tried to get him to tell us more about what he intends to automate. That shortcut menu includes both compact and decompile options. I won't ever use either of them without a fresh backup first.
HansUp
2010-07-26 21:29:49