how run macro using scheduled task on a shared drive

Hello Experts!  I've created a scheduled task to run a macro in an .mdb that resides on a shared drive (I:\), but I can't get it to run, I get the error:
"Microsoft Access can't find the data base file I:\MyDb.mdb - Make sure you entered the correct path and file name"
Here is my script:
"C:\Program Files\Microsoft Office\Office12\MSAccess.exe" "I:\MyFolder\MyDb.MDB" /x mcoExportMyTable
How can I correct this? Is it not possible to run a scheduled task on a file that resides on a server share even if I have admin rights?
jimshockAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
use the UNC for the drive not the mapped drive

"C:\Program Files\Microsoft Office\Office12\MSAccess.exe" "\\ServerName\MyFolder\MyDb.MDB" /x mcoExportMyTable
0
 
jimshockAuthor Commented:
Thank you so much, that did it!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.