Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / November 2006

Tip: Looking for answers? Try searching our database.

Running a remote Batch File

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike Faulkner - 01 Nov 2006 16:52 GMT
Hello

OS: Windows XP
App: Access 2002 SP3

I want to run a batch file placed on another Networked PC. I have tried
'Shell' but I can not get it to run:

Line 1: strPath = "\\LNWSVISBILL06\c$\Data\Data.bat"
Line 2: Shell strPath

The Batch file extracts details of documents in a Temp Folder and places it
into a text file: <dir c:\temp\*.doc /OD > c:\Data\Data.txt>

Any assistance with this problem will be much appreciated.

Regards
Mike
Cyberwolf - 01 Nov 2006 17:21 GMT
Try putting Call in front of Shell

Signature

James Gaylord
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf

> Hello
>
[quoted text clipped - 14 lines]
> Regards
> Mike
Stefan Hoffmann - 01 Nov 2006 17:21 GMT
hi Mike,

> I want to run a batch file placed on another Networked PC. I have tried
> 'Shell' but I can not get it to run:
Any error messages?

> Line 1: strPath = "\\LNWSVISBILL06\c$\Data\Data.bat"
> Line 2: Shell strPath
This should work. Have you checked your credentials? Is the batch
share-aware?

Try running it from the command prompt (cmd.exe).

mfG
--> stefan <--
Mike Faulkner - 01 Nov 2006 18:12 GMT
Stefan

No error messages. I'll check the security permissions tomorrow.

When I map a drive to the batch file and double click it does not run.

Regards
Mike

> hi Mike,
>
[quoted text clipped - 11 lines]
> mfG
> --> stefan <--
Stefan Hoffmann - 01 Nov 2006 20:15 GMT
hi Mike,

> No error messages. I'll check the security permissions tomorrow.
> When I map a drive to the batch file and double click it does not run.
This sounds like a buggy batch.

mfG
--> stefan <--
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.