Solved

VBA - Access Module for SSH FTP

Posted on 2009-07-01
3
1,342 Views
Last Modified: 2013-11-29
I am looking for SSH FTP Functionality in my Access-Application.
Which is the easiest way to implement it?
Are there free components available?
0
Comment
Question by:prooffice
  • 2
3 Comments
 
LVL 16

Expert Comment

by:Chuck Wood
ID: 24755414
0
 

Author Comment

by:prooffice
ID: 24755450
Thanks.
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?
0
 
LVL 16

Accepted Solution

by:
Chuck Wood earned 500 total points
ID: 24755501
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)

  OR

varRet = Shell(rsCom!FilePath & "\" & strBatFileName, 0)

Open in new window

0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Creating an OSPF network that automatically (dynamically) reroutes network traffic over other connections to prevent network downtime.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now