Results 1 to 4 of 4
  1. #1
    LostInTheTrees is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Location
    Tucson
    Posts
    4

    Running code in the background

    I need to execute some SSH operations through an OCX control in my Access program. This all works fine, but SSH is slow to start up and the entire Access program seems to block. Is there a way to execute this in the access program without blocking? Or do I have to figure out some way of performing the SSH in another process?



    -Bob

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Access blocks SSH or SSH blocks Access?

    Exactly what do you want to do in Shell? Maybe you should use VBScript or PowerShell.

    I've never used ActiveX controls.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    LostInTheTrees is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Location
    Tucson
    Posts
    4
    I call the SSH connect command from VBA in Access. It takes many seconds to return. During that time, it appears that much or all of Access is blocked.

    When doing long operations in VBA I know to call DoCmd to let Access handle UI events, but I have no control during this operation.

    -Bob

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    AFAIK, Access cannot run multiple processes - it is single-threaded app.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. vba code running in wrong order??
    By Paintballlovr in forum Programming
    Replies: 3
    Last Post: 08-30-2013, 03:53 PM
  2. Running Code from a Module in a Macro
    By ReadyReckoners in forum Modules
    Replies: 2
    Last Post: 05-08-2013, 04:45 AM
  3. Replies: 1
    Last Post: 12-13-2012, 01:41 PM
  4. Running a code in an inherited Database
    By jlgray0127 in forum Forms
    Replies: 12
    Last Post: 03-14-2012, 02:58 PM
  5. Replies: 4
    Last Post: 08-25-2011, 01:59 PM

Posting Permissions

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