Automating replies to Pop Ups

[Secen]

I have need to automate the encryption/decryption of a
database (docmd.runcommand acencryptdecryptdatabase) - is
there a way I can supply the keystrokes that are required
to fill in the interogation windows that launch requesting
a subject DB name/directory and the target db
name/directory? Any help is appreciated...

 

[Alex Dybenko]

You can use dbengine.CompactDatabase to do so. see online help for more info

 

[Secen]

That works exactly as I'd like. Thank you

On a side note, I couldn't get any of the RunCommand
commands to actually work. I coded a Visual Basic wrapper
(not in the database itself - a stand alone program) with
all the proper references but nothing happened. I
declared a variable of application, set it to the database
and issued appl.docmd.runcommand accmdxxxx against it with
no results for anything. No errors, but no results. How
is Runcommand supposed to be used? Thanks again