Sendkeys to another Access App (2000)

Is it possible to send keystrokes to another Access application? I want to compress the application in question but the only way to close it is to enter a keystroke combination (Alt-W) which was chosen so that it would be unlikely that anybody closed it by accident.

Re: Sendkeys to another Access App (2000)

Hmmm, can't you use DoCmd.Quit?

What I would recommend would be to use the GetObject function. You can use the path to the database, with that statement. That gives you an Automation copy of the object. You can then close it. If you have a form that is open in the background, to prevent someone from closing it with the X, then just close that form from code...sample: