Re: Remote Server shell command

From: Dan Artuso (dartuso_at_NOSPAMpagepearls.com)
Date: 08/21/04 

Date: Sat, 21 Aug 2004 10:49:00 -0400

Hi,
You can look into using psexec.
It's a command line tool used to run an executable on a remote PC.
Of course you need the admin credentials to run it, but you'd need those
anyway
to do anything on a remote server.

http://www.sysinternals.com/ntw2k/freeware/psexec.shtml

>From within your local db, just Shell out to psexec.

HTH
Dan Artuso, MVP

"Joel Wiseheart" <anonymous@discussions.microsoft.com> wrote in message
news:9c0c01c486c5$2c556610$a501280a@phx.gbl...
> First, the question: Is there a way to use Access VBA to
> run a command line program on a remote server?
>
> Here's the situation: I have a new Access 2002 client app
> that will be distributed to many PC's, with the back-end
> data stored in a different .mdb file on a remote server.
>
> There is a utility called TablePro, that can extract data
> from our 'SAP' ERP system to an Access .mdb file (That's
> why I'm using .mdb's and DAO instead of SQL and ADO). The
> licensed copy of it is on the server.
>
> I need to run TablePro through the command line, which
> has command line parameters to adjust the WHERE clause of
> the particular data extraction profile to be run. For
> example:
>
> Shell ("C:\Program
> Files\WinShuttle\TablePro\TablePro.exe " _
> & "233, {W1} = 12345678"
>
> The '233' is the TablePro "profile number," and
> the '{W1}' is used to pass criteria to the profile WHERE
> clause.
>
> So, if the client .mdb file is on a client PC, is there a
> way to run the TablePro.exe file on the remote server
> from the client?
>
> Thanks!
>
>
>

Relevant Pages

  • Registering a Remote Server With Client Tool
    ... A user at a workstation running the Personal Edition (client tools only) ... register using the sa account & password, ... This Windows user was already defined a a valid trusted login in the remote ... remote server, there is a box checked that reads "Allow other SQL Servers to ...
    (microsoft.public.sqlserver.security)
  • Remote Server shell command
    ... run a command line program on a remote server? ... I have a new Access 2002 client app ... data stored in a different .mdb file on a remote server. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Citrix Pen Test,
    ... The way its works is that the client need to connect ... to the remote server through Citrix and run the application. ... I noticed that the Citrix Client used ...
    (Pen-Test)
  • Re: Net::SSH::Perl - Broken Pipe
    ... Not sure why you are getting a broken pipe. ... command line of your dev box to the remote server? ... command on a remote system. ...
    (comp.lang.perl.misc)
  • Re: third post: Marshal by value remoting
    ... How To Marshal an Object to a Remote Server by Value by Using Visual Basic ... Sam Santiago ... > of assemly in my computer (in client) and if I change the class to inherit ...
    (microsoft.public.dotnet.framework.remoting)