Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Automate a macro to run on a schedule.

Posted on 2004-04-12
2
Medium Priority
?
428 Views
Last Modified: 2009-12-16
MSAccess 2000 on a windows 2000 Network. I have a table that I would like to copy out of the database into another database. I have a macro to do that but what I'm trying to do is schedule for that macro to run every night. I seen a third party app that can schedule a macro it was like 35 bucks. I'm just looking for any alternatives.

0
Comment
Question by:jaze95
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 600 total points
ID: 10807472
Hello jaze95,

Use the Windows scheduler to start Access with your database. Look at Scheduled tasks in Control Panel.  You can specify a macro to run when the database opens in the command line using the /X macroname switch.
See command line in Help.

Pete
0
 
LVL 39

Expert Comment

by:stevbe
ID: 10807559
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question