supress the decompile msgbox

[Tony]

how do I supress the decompile msgbox
the one that says
the code has been converted to the current version of VB

I've got a commandline batch routine that will open the
database, decompile the code, compile the code, and
compact the db
this is hopefully going to be run once a month (after
hours) using the windows scheduler

routine looks like:
"\\Bshnt1\apps\winapps\office97
\Office\msaccess.exe" "p:\building\mph_fee\Fee_Predictions.
mdb" /decompile /x CompileMod

where CompileMod is a module to compile and compact the db

problem is I don't want user interaction
at the moment, the user needs to click ok on the decompile
msg before the module is run
(which is stupid seeing as this is meant to happen when no-
one's around)

cheers peeps.
Tony

 

[Stephen K. Young]

At run time, you should not need to decompile at all. The code should not be
changing. Deliver a compiled .mde if you are worried about VBA decompiling.

At build time, in development, your batch file can add a special "/cmd quit"
or other parameter that tells your startup code to quit. Your batch file
looks something like:

%AccExe% %1 /decompile /cmd quit

Your VBA startup code has something like this:

If Command$() = "quit" Then
Application.Quit acQuitSaveNone ' quit after a batch file decompile or
compact
End If

- Steve