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\S hareName\FileNa me.bat"
strPath = Chr$(34) & strPath & Chr$(34)
Call Shell(strPath, 1) 1 2958
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******** *************@c 13g2000cwb.goog legroups.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\S hareName\FileNa me.bat" strPath = Chr$(34) & strPath & Chr$(34) Call Shell(strPath, 1) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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, however when I try and
compile the project I get two error messages:
1) Could not copy temporary files to the output directory.
2) The file 'bin\IADB_ASP_NET.dll' cannot be copied to the run
directory. The process cannot access the file...
|
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 project we copy it directly with the
'copy project' command from visual studio .NET to server B (in Release
mode). Then, because the production Server is at the customer and we
|
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 copy files into that directory
on my PC!
thanks.
|
by: Tom C. |
last post by:
Does anyone know how to add the File System Editor to a Visual Studio 2003
installation?
Thanks!
|
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 project
'http://localhost/MyApp/MyApp.csproj'. The web sever reported the following
error when attemptimg to create or open the web project located at the
following URL: 'http://www.mysite.com'. 'HTTP/1.1 500 Internal Sever Error'
More details:
| |
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 the libraries that we wish
to debug to the solution, and make project references to the other projects
within the solution. All other library references would be file references,
since they were not included in the solution.
However, the...
|
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.
************************************************************
The class EmailPoller can be designed, but is not the first class in the
file. Visual Studio requires that designers use the first class in the
file. Move the class code so that it is the first class in the file and try...
|
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 front end with a SQL server
backend. It sounds like a good way for me to begin to learn about SQL
server.
I have thought about just shelling out the bucks for a copy of Access
2003, but the adp software is really the only reason. Do the folks
|
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. However, after I alter the
table and open microsoft excel to look at any changes; I get the
following error: "This file is not in a recognizable format" If I do
open the file in excel it looks like its not formatted.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |