Results 1 to 2 of 2

Cant run batch file from macro

  1. #1
    tagteam is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    317

    Cant run batch file from macro

    I have tried a macro using RunApplication and VBA



    Dim RetVal
    RetVal = Shell("S:\SaveImportedFiles.bat", 1) ' File Archiver

    A bop pops up for 1/4 of a second, I cant even read it just see an outline, and then it fails.

    I am trying to run this from a terminal server. I access the database that is on the terminal server from an icon on my desktop. The batch file is located in a shared file that is accessible from the terminal server.

    Does anyone know why this is not working. Is it some kind of permissions issue or something? When i am logged in to the terminal server and i navigate to that shared folder and double click the batch file it works.

    Thanks

  2. #2
    tagteam is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    317
    Sorry, I figured this out. It was a problem with the paths in the actual batch file.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Open and log in to database through batch file
    By spacekowboy in forum Access
    Replies: 9
    Last Post: 11-02-2015, 03:22 PM
  2. Batch Command to Run Macro Crashes
    By dssrun in forum Programming
    Replies: 4
    Last Post: 02-07-2012, 02:11 PM
  3. Replies: 4
    Last Post: 01-26-2012, 01:34 PM
  4. Run batch file
    By shay in forum Access
    Replies: 3
    Last Post: 12-15-2010, 09:47 AM
  5. Running Batch File
    By NoiCe in forum Programming
    Replies: 2
    Last Post: 03-21-2010, 07:05 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums