Solved

VBA - Access Module for SSH FTP

Posted on 2009-07-01
3
1,347 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
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…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

825 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