Solved

FTP upload from Access 2002/2003

Posted on 2004-04-04
7
238 Views
Last Modified: 2006-11-17
I just want some code to upload a file from within access to an ftp site using a logon and password

Thx

Marion
0
Comment
Question by:MaVi
  • 4
  • 2
7 Comments
 
LVL 65

Expert Comment

by:rockiroads
ID: 10752292
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 10752302
For some sample VB Code, have a look at this website

http://vbnet.mvps.org/index.html?code/internet/dofiledownloadcustom.htm
then click on in the Related to section;    FTP: Downloading Files via FTP
0
 

Author Comment

by:MaVi
ID: 10752817
I had a look and tried some things
Seems not to be working with ACCESS 2002/2003

Just want some easy code

Thx

0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 65

Expert Comment

by:rockiroads
ID: 10752942
ok, I must admit, I have used WinInet but in a VB program and that was a few years ago, its pretty good
I havent tried with Access but I thought it would work considering its VB/VBA code

ok try this from microsoft, also gives sample code


http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q163/6/53.asp&NoWebContent=1

0
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
ID: 10755200
did this simple approach work? (link I posted earlier)

http://www.mvps.org/access/modules/mdl0015.htm
0
 

Author Comment

by:MaVi
ID: 11136812
I found the solution here
http://www.mvps.org/access/modules/mdl0037.htm
Maybe not the best or the most elegant but it works OK
This link was on one of the pages you refered me to, so I'm giving you the points

Thanks & Greatings,

Marion
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
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…
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…

735 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