Access-to-MSSQL does not support automation directly, but it is supplied with command line version a2magent.exe that can be called from any script. So, it is possible to write a simple batch script and execute it automatically using Windows Task Scheduler.

Refer to Command line article to learn more about a2magent.exe.

Have more questions? Contact us