Hi All,

Please help...

I have a command line to open Access and execute a macro. But how do I close Access when the macro is executed successfully?

Thanks in advance!!

To open Access and execute macro:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "\\database\mydb.mdb" /xMyMacro

Is your macro written in VBA? If so, just add a line at the end and type...

Application.Quit

Hope that helps

Mike

Mike
EchoVue.com

Mike,

Thanks much for the quick response.

No, it is scheduled through Windows scheduler. Any ideas?? Thanks.


Start/All Programs/Accessories/System Tools/Scheduled Tasks/Add Scheduled Task

Are you able to edit the Macro itself?

Mike
EchoVue.com

I agree with Mike, you have to add the command within the Access MDB. It does not matter how you open the MDB.

After all the procesing is done within the Access MDB, then you add the Access command to "Quit".

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com

Thanks to echovue and AccessMaster!!

There were two problems for my problem:
The vesion of my Access is 2003 and the db version is 2002 so I was using the wrong version to open the db.
After I changed the following from
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "\\database\mydb.mdb" /xMyMacro
to
"C:\Program Files\Microsoft Office\OFFICE10\MSACCESS.EXE" "\\database\mydb.mdb" /xMyMacro
and
added the Quit/Exit action to the macro I was executing, it was working like a charm.

Thanks to all of your prompt responses. I really appreciate it.