running an Access Macro or Report unattended as a scheduled task.

K

Kevin B.

I have created a simple Macro in Access that opens a report and prints it
then closes the report and exits access and it works perfectly when I run it.

I want this to run unattended so i create a batch job that simply runs the
macro and when I execute the batch job it works.

This is the command in the .bat file.

"e:\program files\officexp\office10\msaccess.exe" "path\databasename.mdb"
/nostartup /x macroname

The problem I am having is if I create a scheduled task in windows to run
the batch file, It hangs as though its waiting for something. I am unable to
see what its doing because its running in the background like I want it too.

Does anyone know how to run an Access Macro unattended as a scheduled task.

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Access from Command Prompt 7
Access won't open from batch file when scheduled 3
MS Access and Window scheduled task 13
Msaccess.exe Running in the Task Manager 2
No Current Record Error, Scheduled Task 4
macro process running in task manager after the job is done 3
Running Outlook as Scheduled task 1
Running a Query and a Report through a scheduled task 4

Top