Re: Remote Server shell command

From: John Nurick (j.mapSoN.nurick_at_dial.pipex.com)
Date: 08/20/04 

Date: Fri, 20 Aug 2004 19:49:05 +0100

Hi Joel,

I've never tried this myself but AFAIK you use WMI, Windows Management
Instrumentation, which is part of the Windows scripting facilities and
can therefore be used from VBA.

Make sure, however, that your TablePro licence covers this "server-side"
use.

On Fri, 20 Aug 2004 07:51:28 -0700, "Joel Wiseheart"
<anonymous@discussions.microsoft.com> wrote:

>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!
>
> 

--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.

Relevant Pages

  • 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)
  • Access DB Issues - Again
    ... Remote server hosts a .mdb file but the client cannot access the DB through ... One can use VB.Net Express 2005 to write a client resident application to ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Access DB Issues - Again
    ... ¤ VB.Net Express 2005. ... One can use VB.Net Express 2005 to write a client resident application to ... access an .mdb file living on a remote server. ...
    (microsoft.public.dotnet.languages.vb)
  • Web Services Updating List Content
    ... client application on remote server that passes data web service. ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: YANQ (Yet another newbie Question)
    ... Create client access to a remote server by using Visual C++ .NET ... > when the client tries add an event to a public delegate on the server. ...
    (microsoft.public.dotnet.framework.remoting)
Loading