We help IT Professionals succeed at work.
Get Started

Scheduled execution

mlcktmguy asked
Last Modified: 2014-05-05
I remember reading that it was possible to initiate Access from a batch file using startup parameters but I really don't know anything else about it.

I have a production MDE that is used by the client every day.  It is set up with an autoexec macro that performs some housekeeping and then opens the main screen/ menu of the application.  

When I setup my scheduled process I would probably want the MDE to open and automatically run a certain function rather than the 'autoexec' macro.   Is it possible to override the execution of the autoexec?

I have a process that I would like to schedule to run every evening on my client server.  They would set up the task on a scheduler and suggested that I set up a batch file to initiate the process.

What would the line that initiates Access from the batch file look like?

Any help would be appreciated.
Watch Question
Distinguished Expert 2017
This problem has been solved!
Unlock 3 Answers and 9 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE