Solved

VBA - Access Module for SSH FTP

Posted on 2009-07-01
3
1,352 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
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 …
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…

738 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