cmd batch file question

[bonehead]

Greetings,

Apologies in advance for the cross-posting. I'm not certain which is the
best group to post this to.

I don't use cmd.exe very much and I don't write batch files very often.
Hopefully this is a simple question with a simple answer.

Here is a batch job which I can run at will, or as a scheduled task. The
batch job starts MS Access, opens the specified file, and executes the
specified macro (which, in turn, invokes a VB function in a module):

"C:\Program Files\Microsoft Office\Office11\msaccess.exe"
"C:\MyFilePath\MyDatabaseName.mdb" /X MyMacroName
exit

Note that wrapping in certain newsreaders may make it appear that there
is a carriage return after the call to msaccess.exe, but this is not
actually the case. The only carriage return is before the exit command.

Can I modify this so that after the macro executes, the .mdb file
closes, MS Access exits, and the cmd shell closes? Currently I have to
close MS Access manually to return the focus to the shell, then the
shell performs the exit command and closes on it's own.

Suggestions?

 

[muharram]

you can write some macro in your access db, like this, and call it at
the end of previous macro:

Application.Quit acQuitSaveAll

 

[Wesley Vogel]

Type taskkill /? in a command prompt. taskkill /im msaccess.exe

exit will close cmd.exe.

Exit quits the CMD.EXE program (command interpreter) or the current batch
script.

You did not crosspost, you multiposted!

[[If a message MUST be posted to multiple groups, post a single message and
select all the groups (or type their names manually, separated by commas) in
which you want it to be seen. This is called Crossposting and when used
properly it is *GOOD*.

This question was posted individually to multiple groups.

This is called Multiposting and it's *BAD*.

Replies made in one group will not be visible in the other groups, which
may cause multiple people to respond to a question with the same answer
because they didn't know someone else had already done it.

This is a waste of time. ]]
--
Hope this helps. Let us know.

Wes
MS-MVP Windows Shell/User

In

 

[bonehead]

you can write some macro in your access db, like this, and call it at
the end of previous macro:

Application.Quit acQuitSaveAll

Thanks, hadn't thought of it, but it worked.