Task Scheduler BAT file or Not

[jarett]

Trying to schedule Access to open up every day at a certain time. When I go straight to the db file and open it my AutoExec macro runs and exports the file I specificed. However when I run the task in the task scheduler it opens access and gets to the export and errors. It says file path unknown make sure path is connected to the network. I was trying to go a bat file way but getting stuck?

 

[Joe4]

Where is it trying to export the file to?
On the computer it is running from, does it have rights to that exact path (under whatever user you are using on the Computer when running Task Scheduler)?

 

[jarett]

Yes, it is on the computer I am running from, well not the actual computer but a drive on our network. I read a few articles saying the "Run only when user is logged on" needs to be checked and I did that.
This is the error.

 

[Joe4]

From the server as the logged on user, are you able to browse to that database from File Explorer and open it up?
What happens if you try using UNC naming convention instead of drive letter "M"?

 

[jarett]

I messed something up, now I'm getting. I must of did something when trying to run a batch.

 

[jarett]

I messed something up, now I'm getting. I must of did something when trying to run a batch.
View attachment 37550

BAT file sorry, this was tring to open the file straight from access.

 

[Joe4]

Are you trying to run a batch file from the Scheduler, or open the database directly from the Scheduler?
Is Microsoft Access installed on your server?

 

[jarett]

Originally I was trying to open database from the scheduler, it would open access but not the database. Update in middle of post, had to recreate db and tried saving the db on the "C" drive and still export file to server. Now task scheduler works and the AutoExec runs smoothly. Not sure if this is best practice but it works for me.