473,729 Members | 2,042 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

run access.exe on server side

Gil
can i have a client pc trigger access.exe to open on the server side
pc?
i want to have the server run special functions and return the output
to the clients without having the clients run the functions itself.

Jan 11 '06 #1
28 4845
"Gil" <gi*******@gmai l.com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .
can i have a client pc trigger access.exe to open on the server side
pc?
i want to have the server run special functions and return the output
to the clients without having the clients run the functions itself.

There may well be no need for anyone to run Access - it depends what these
'special functions' are. What software will the clients have? ie how will
they initiate these commands and how will they receive notification of the
status? Do the clients have ms access installed or would you need to run
these functions using soemthing else, eg a web browser.
Jan 11 '06 #2
Strictly answering your question, yes, you can have your client PC run
MSACCESS.EXE on the server by using the Shell command. The syntax is:
Shell "Path:\To\MSACC ESS.EXE"

This spawns a command window and calls the program file directly.

However, you'll want to call your custom database on the server, if you
want "special functions" to run - MSACCESS.EXE just opens the parent
MDI window. So instead, you would use Shell "Path:\To\Custo mMDB.mdb"
and put your "special functions", whatever they may be, in the
Form_Load event of your startup form.

Jan 11 '06 #3
Steve wrote:
Strictly answering your question, yes, you can have your client PC run
MSACCESS.EXE on the server by using the Shell command. The syntax is:
Shell "Path:\To\MSACC ESS.EXE"

This spawns a command window and calls the program file directly.


That will certainly not work. Calling an exe on another computer will not
work if that exe is one that requires an actual "installati on" program (as
most do). The system will still look for all support files and registry
entries on the local PC and since they don't exist the executable will fail
to run.

For an executable like Calculator that is completely self-contained then it
would work, but the exeutable "on the server" would still actually be
executed on the local PC using local resources. The executable file would
simply be pulled over the LAN and loaded into local memory.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Jan 11 '06 #4
Rick, you make a very good point. The MSACCESS.EXE file would be run on
the server itself, but all other resources would be pulled off of the
client machine.

In theory (completely untested, just throwing this out), you would be
able to write a quick batch file that opens the desired MDB file, then
place the batch file on the server and call that instead of calling the
MDB file directly. Gil, an example of such a batch file would be:
start "Drive:\Path\To \MDB"

I'm probably missing a couple of switches on that. I think I have a
batch script that opens a particular MDB file, but I'll have to look
for it to get the exact, working syntax.

Rick would know more about how the batch file on the server will locate
resources than I do, but I can see where this could work and where it
wouldn't. The only way I know to find out is try it.

Jan 11 '06 #5
Steve wrote:
Rick, you make a very good point. The MSACCESS.EXE file would be run
on the server itself, but all other resources would be pulled off of
the client machine.
Still incorrect. Even if all of the necessary additional resources were
available locally then the MSAccess.exe file on the server would be loaded
into local memory and it would still be executed by the local PC. This
would be no different then double-clicking an executable in Network
Neighborhood. When you do that you are telling your local copy of Windows
to execute this file on the network. If it runs it will be running on the
local box, not on the remote box.

To make a program actually run on the remote box you have to somehow tell
the OS on the remote box to run the program. In most cases this is not
possible unless you have some sort of special program on your PC that can
issue commands to other PCs.
In theory (completely untested, just throwing this out), you would be
able to write a quick batch file that opens the desired MDB file, then
place the batch file on the server and call that instead of calling
the MDB file directly. Gil, an example of such a batch file would be:
start "Drive:\Path\To \MDB"


You might be able to *Schedule* the batch file using the scheduler on the
server, but you would not be able to call it. Calling it would just do as
described above which is to attempt to run the remote program inside the
local OS. A scheduler on the remote box would differ in that now the OS on
the remote box is telling itself to run the program.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Jan 11 '06 #6
One way that this could be accomplished is with the use of a program called
psexec. It is part of a superb freeware collection from a marvelous company
called SysInternals and will permit a workstation to execute a program on
another system.

The more complex part would be returning the data to the calling client. If
there were just one or two clients, the server could be configured to push
the data out to whichever client called it. If there were many, the clients
would probably have to be configured to "retrieve" the data after the server
produced it.

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.
"Gil" <gi*******@gmai l.com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .
can i have a client pc trigger access.exe to open on the server side
pc?
i want to have the server run special functions and return the output
to the clients without having the clients run the functions itself.


Jan 11 '06 #7
In message <11************ **********@g14g 2000cwa.googleg roups.com>,
Steve <th*********@gm ail.com> writes
Rick, you make a very good point. The MSACCESS.EXE file would be run on
the server itself, but all other resources would be pulled off of the
client machine.

In theory (completely untested, just throwing this out), you would be
able to write a quick batch file that opens the desired MDB file, then
place the batch file on the server and call that instead of calling the
MDB file directly. Gil, an example of such a batch file would be:
start "Drive:\Path\To \MDB"


That's fine but remember that the batch file has to be executed on the
server too.

It is possible to do that but it's a complicated process involving
semaphores and I wouldn't want to try to set it up unless it was
absolutely essential. I haven't yet seen the OP explain why they need to
run the process on the server.

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author.

Jan 11 '06 #8
Gil
THANSK for all of your replies.
I know php can do this. Since php is a server-side application, it has
a function called exec() which will run a program on the server-side. I
could have a clients access program load the php site which calls a
batch file that calls an access macro (ie. start "c:\access-file.mdb"
\x "macro-name"). that access function can put the data on a text file
or in a database, and from there the client can than retreive it.
i wonder if it would take long to happen, and how the client will know
to wait while the server is doing the work. and what will happen if
more than one client call the function at once.
could i do something like

do while text-file.txt is empty
output = text-file.txt
loop

i want the server to run mappoint and get mileage between 2 address'
while not having to install mappoint on every client machine.
i know mappoint web service can do this but i want to work around that.
i think my idea can work.

Jan 11 '06 #9
"Gil" <gi*******@gmai l.com> wrote in
news:11******** **************@ z14g2000cwz.goo glegroups.com:
i want the server to run mappoint and get mileage between 2
address' while not having to install mappoint on every client
machine. i know mappoint web service can do this but i want to
work around that. i think my idea can work.


What in the *world* does it have to do with Access?

I see nothing at all.

Use ODBC or ADO from PHP to run SQL against your Jet database (which
you may have created with Access, but when used from PHP, Access is
not involved).

Unless you want to execute VBA code in the Access database or
utilize Access reports (which are better than any other available
report writer), there is absolutely no reason for running Access in
this scenario.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jan 11 '06 #10

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

Similar topics

4
8198
by: Si | last post by:
Hi Guys I am using this code to execute an Access VBA function from ASP: strDbName = strDataSource & "data\webjobs.mdb" Set objAccess = Server.CreateObject("Access.Application") objAccess.Visible = False objAccess.OpenCurrentDatabase strDbName objAccess.Run "ASP_SkillSearch", strTable, oUpload.Form("firstname"), oUpload.Form("surname")
6
3431
by: Jegger | last post by:
Hello! We have following situation; network with 100 users, aplication developed in Access, user DB deployed on SQL Server. Is it better to create query inside aplication (with code) and then pass it to SQL Server for execution or is it better to have all these queries saved like stored procedures and then called from aplication?
3
43947
by: Robert Oschler | last post by:
I know there isn't any $_POST array in Javascript, it exists on the server side accessible from PHP and other server side scripting languages. But I knew it would let you know specifically what data I'm after. Is there any way to get the data that is POSTED to a web page from client-side Javascript? Or does only the server get access to it? I can get access to the URL/href data from the "search" property, but that's because it's part...
55
3552
by: AnandaSim | last post by:
I just had a google through this NG but have not seen mention of Erik Rucker's blog entry and the new Jet: http://blogs.msdn.com/access/archive/2005/10/05/477549.aspx mentioned by Mike Gunderloy http://www.larkware.com/dg4/TheDailyGrind726.html Aside from the Sharepoint feature extension, amazing news.
3
3491
by: Lyle Fairfield | last post by:
In a recent thread there has been discussion about Data Access Pages. It has been suggested that they are not permitted on many or most secure sites. Perhaps, that it is so, although I know of no site that has this prohibition, and I have uploaded DAPs to various sites and used them from those sites. I do not understand why any site manager would prohibit DAPs. To the best of my knowledge DAPs, as HTM files, are merely hosted on the...
3
6127
by: Yohancef Chin | last post by:
Hi, Being fairly new to .NET I am looking for a way to call MS Word from an event on a webform, and after the user is finished save that created document to an SQL Server database. Has anyone done this? Does it seem possible? I followed the instructions from a sample on the Microsoft knowledge base but it only seems to work when creating a VB.NET Windows .EXE, not an VB.NET ASP app.
2
1905
by: adolf garlic | last post by:
I have an aspx which has some client side script. The client side part of the page also features an xml data island What I want to be able to do is to get at the data island from the server side part of the page. I've managed to do it with a simple text field using client side <input type="hidden" runat="server" id="funcParam" NAME="funcParam">
7
7001
by: Lau Lei Cheong | last post by:
Hello, I'm using javascript's insertAdjacentHtml() to insert images to the webform at runtime. This runs fine(image successfully displayed at the browser) but when I tried to access the control's src using FindControl() function in the code-behind, it seems that the control doesn't even exist. I know that I can add controls on the server-side, but then a postback will be needed which is the thing I want to avoid. Does anyone have idea...
7
2946
by: tshad | last post by:
How do you hide an asp.net object and still be able to access it? I had my email in a session variable, but you can't access the session variable from Javascript (I don't think - since Javascript is Client and Session is Server). I tried using the email that was on the page, but it was surrounded by a Panel that had its visible property set to false - so anything inside of the Panel was not on the page.
0
8928
marktang
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...
0
8766
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,...
0
9428
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9291
jinu1996
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...
0
9158
tracyyun
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...
0
8160
agi2029
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...
0
6026
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4799
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3244
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.