I have an Access 2003 project. I need for users to be able to run a
report and copy the report in Excel format to a web server. The problem
is, they do not have write access to the web server. I tried to have
the Excel file saved to a public directory and then have a bat file run
(from Call Shell in Access) to copy it to the secure directory, but to
no avail. The problem is, the bat file, although located on a server,
is executed from the user's workstation thus using their security. Is
there anyway to force the bat file to run on the server or to add a
login and password to the path in the Call Shell routine? Here is the
current Call Shell:
dim strPath as String
strPath = "\\ServerName\ShareName\FileName.bat"
strPath = Chr$(34) & strPath & Chr$(34)
Call Shell(strPath, 1)