By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,704 Members | 1,944 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,704 IT Pros & Developers. It's quick & easy.

access 2003: ftp question

P: n/a
How can I use FTP from Access 2003 with Windows 2003.
Any suggestions?
Thanks - jung
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
you can use the runapp command in a macro to try running the
c:\windows\system32\ftp.exe program

this is the ftp program that is run from the command prompt when you type in
something like "ftp 123.123.123.123"

you would have to figure out a way to make it interact for opening the
connection and logging in and such--this is most easily accomplished with a
file containg ftp commands (see the help for ftp by typing ftp /? at the
command prompt or by doing a search in windows help)

you can also run this by using the Visual Basic SHELL object if you are
looking to do it using VB code--this is more flexible ( i think) but more is
involved.

Are you looking to ftp something that is coming from access itself (a table,
report, etc)?

"JMCN" <pi******@yahoo.fr> wrote in message
news:27**************************@posting.google.c om...
How can I use FTP from Access 2003 with Windows 2003.
Any suggestions?
Thanks - jung

Nov 13 '05 #2

P: n/a
pi******@yahoo.fr (JMCN) wrote in message news:<27**************************@posting.google. com>...
How can I use FTP from Access 2003 with Windows 2003.
Any suggestions?
Thanks - jung


There's code here...
http://vbnet.mvps.org/

FTP: Downloading Files via FTP
and here...
http://www.mvps.org/access/modules/mdl0015.htm
Nov 13 '05 #3

P: n/a
pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...
pi******@yahoo.fr (JMCN) wrote in message news:<27**************************@posting.google. com>...
How can I use FTP from Access 2003 with Windows 2003.
Any suggestions?
Thanks - jung


There's code here...
http://vbnet.mvps.org/

FTP: Downloading Files via FTP
and here...
http://www.mvps.org/access/modules/mdl0015.htm

thank you all for your advise and resources!!
cheers - jung
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.