I have an MS Access 2007 app that I would like to open using Server 2008 task scheduler. When opened, an autoexec macro is run and the app is automatically closed using VBA.
When I launch the app using windows explore or open access and choose the database to open, the macro runs and the database closes. This is good!
I then created a batch file that Calls the database, and that also runs without problems.
When I created a Scheduled Task, the database opens and runs, but does not close. Does anyone know why this is happening.