473,320 Members | 1,914 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Copy file from within Access 2003 project

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)

Nov 13 '05 #1
1 2939
Although it is an Access Report, this is not an Access question.

As far as I know, you do have to have proper permissions to write to a
server. An alternative might be to put the file(s) in a folder that you
share and put code on the server to copy it(them) on a time-scheduled basis.
But, it'd be an appropriate question in a newsgroup about the Operating
System you run on the server.

Larry Linson
Microsoft Access MVP

"gale" <ga********@ncr.com> wrote in message
news:11*********************@c13g2000cwb.googlegro ups.com...
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)

Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: lasmit | last post by:
I am having some troubles with a project I am working on not building correctly. I converted an old ASP project to .Net and then have been adding pages to the project in C#. This all works ok,...
1
by: Adrian | last post by:
Hi all Initial postion: IIS 6.0, Windows 2003 Server, .NET Framework 1.1 We have a development Server A, a stating Server B and a production Server C. After development of the .NET ASP...
4
by: John Blair | last post by:
Hi, Can anyone tell me how to make the Copy Project option work from within Vb.net - it fails on my PC with an error saying the new copy directory is marked as executable and i am not allowed to...
4
by: Tom C. | last post by:
Does anyone know how to add the File System Editor to a Visual Studio 2003 installation? Thanks!
2
by: camp | last post by:
I use VS.Net 2003 on Win XP Pro SP2. I created an ASP.Net app on local IIS. Now I just wanted to "Copy Project" to remote server, but I get this error: "An error occured while copying the...
3
by: Jerad Rose | last post by:
This is regarding Visual Studio 2003 (framework 1.1). We have several projects/libraries. Of course, many of these reference each other. If we only had one solution, we would simply add all of...
7
by: tshad | last post by:
I have a problem with a VS 2003 project. This project was designed and works fine in VS 2003. But trying to open the project I get the following error....
6
by: Donald Grove | last post by:
I do programming in Access 2000 and 2003. I don't have a copy of 2003 myself, though. I have read about the adp software that comes with Access 2003, that converts an application to an access...
9
by: JimmyKoolPantz | last post by:
IDE: Visual Studio 2005 Language: VB.NET Fox Pro Driver Version: 9.0.0.3504 Problem: I currently have a problem altering a DBF file. I do not get any syntax errors when running the program. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.