Solved

VBA - Access Module for SSH FTP

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

Network it in WD Red

There's an industry-leading WD Red drive for every compatible NAS system to help fulfill your data storage needs. With drives up to 8TB, WD Red offers a wide array of solutions for customers looking to build the biggest, best-performing NAS storage solution.  

Question has a verified solution.

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

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

867 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

24 Experts available now in Live!

Get 1:1 Help Now