?
Solved

Automate a macro to run on a schedule.

Posted on 2004-04-12
2
Medium Priority
?
426 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

752 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