MARS is not only a Access reports scheduler, or macro automation tool, you can also schedule Microsoft Access queries. Today’s guide will walk you through scheduling the query, formatting it, and then delivering it to a destination (email, fax, FTP, SharePoint). MARS is a dedicated scheduler that allows you to perform Access scheduling without the need to fuss with batch files, coded .exes or the Windows task scheduler.
- First create a schedule. This can be a simple single query schedule, a packaged query schedule or even the more advanced data driven distribution schedule. In this case we will focus on the single query schedule.
- Browse to select your access database. Then select query export, and use the dropdown box to select the desired query.
- The next step is where you set the schedule for your Microsoft Access queries. MARS offers more scheduling flexibility; allowing you to set queries on hourly, event driven, by a customized calendar and more.
- Select the destination and format for your query. You can send the query’s results via email, SharePoint, FTP, Fax, or Printer. Moreover you can format the report as a PDF, Excel, Text, and more.
- The next steps include the ability to take snapshots of the query and archive the results as the query is generated. Since MARS has its own proprietary scheduling engine, there are a number of options around dealing with blank results, or errors. If the query is blank, or the schedule errors, you can be notified by email or text message.
- In the final step, you can set tasks either before the query or after. Perhaps a macro needs to run following the query? Or maybe you want to be notified with the schedule completes? Even complex tasks such as auto updating database records can be triggered along with the query.
- Clicking finish, your schedule is ready to go. No manual intervention is needed afterwards.
Since MARS is a dedicated 3rd party scheduler for Microsoft Access there is no need to worry about database locking issues, or dealing with the woes of Windows task manager. Moreover you can manage queries and reports from multiple Access databases, making it much easier for you to manage processes. You can also schedule Microsoft Access queries using MARS’ advanced schedule types. They allow you to dynamically populate queries, or trigger queries based on events. Either way, you will never have to put up with the headache of manual intervention again!
Republished by Blog Post Promoter
- See more at: http://www.christiansteven.com/how-to-schedule-microsoft-access-queries-using-mars#sthash.4Kd7TF58.dpuf