Solved

how run macro using scheduled task on a shared drive

Posted on 2007-11-28
2
1,342 Views
Last Modified: 2012-06-27
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?
0
Comment
Question by:jimshock
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 20368523
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
 

Author Closing Comment

by:jimshock
ID: 31411515
Thank you so much, that did it!!
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question