• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1369
  • Last Modified:

VBA - Access Module for SSH FTP

I am looking for SSH FTP Functionality in my Access-Application.
Which is the easiest way to implement it?
Are there free components available?
  • 2
1 Solution
Chuck WoodCommented:
proofficeAuthor Commented:
Does this involve a DOS-Box flashing up for a sec?
The client doesn't want a DOS-Box to be seen. Even if it is just for a sec...
Is there another approach?
Chuck WoodCommented:
In the example, you can use vbHide (0) to hide the DOS-Box. It will never be seen. Of course you can use vbNormalFocus (1) while you are developing.
varRet = Shell(rsCom!FilePath & "\" & strBatFileName, vbHide)
varRet = Shell(rsCom!FilePath & "\" & strBatFileName, 0)

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now