What is the best way to automate emailing reports from Access using a virtual machine?
Posted on 2015-01-05
I currently have an old desktop PC that is serving as my reporting computer. It is running Windows XP, and uses the windows task scheduler to open Access and run queries, some of which get emailed out using Outlook.
The PC has seen better days and we now are trying to transition to a virtual machine. When the PC is working well, it does not require any user interaction. This is what we are shooting for with the virtual machine as well. However, here are my issues:
1. The VM is running Windows 7 and the task scheduler will not open Access to run a database.
2. When minimizing the VM, it seems to halt any DB application that was running.
What is the best way to get around these issues and have something that can be scheduled on the VM and run without having a user babysit it?