Automate access and make it invisible
Hello all,
I'm automating an access database process, but I would like for it to happen in the background if possible.
Currently, I have an AutoExec macro in Access 2003 that calls VBA code to run the process. Access is started as a Scheduled Task in Windows XP SP2. This is set to run in mid morning. Everything works spendidly, but when it starts, Access pops up on my screen, taking the focus and runs its process, then shuts down. Is there a way to start Access in a hidden state with the task scheduler or through a command line? Or would I be able to put in some VBA code to start the app invisibly?
Thanks,
Ranthalion
Re: Automate access and make it invisible
You might be able to hide it once it starts, but I don't know if you could stop it from displaying at least briefly. Presumably your code/macro is in Access, & won't run until Access itself starts, so any code to hide it would come after it starts.
There may be a way to hide it before it starts, but that would be outside Access itself, in whatever starts the program.
Maybe something like this would help?