FTP from Access?

[news2]

Right now I'm using a "crummy" technique to FTP files to and from our server
- writing a script to the hard drive and then executing a waitshell.

There must be some other way to do it, direct from Access. Pointers would be
appreciated.

Dick

 

[Rick Brandt]

Right now I'm using a "crummy" technique to FTP files to and from our
server - writing a script to the hard drive and then executing a
waitshell.

There must be some other way to do it, direct from Access. Pointers
would be appreciated.

Dick

See if this helps...

http://www.mvps.org/access/modules/mdl0037.htm

 

[Dirk Goldgar]

In

Right now I'm using a "crummy" technique to FTP files to and from our
server - writing a script to the hard drive and then executing a
waitshell.

There must be some other way to do it, direct from Access. Pointers
would be appreciated.

I've used this:

http://www.mvps.org/access/modules/mdl0037.htm

And I've been meaning to try out this:

http://www.chilkatsoft.com/ChilkatFtp.asp

which has been highly recommended by MVP Steve Schapel, and looks really
nice.

 

[news2]

And I've been meaning to try out this:

http://www.chilkatsoft.com/ChilkatFtp.asp

which has been highly recommended by MVP Steve Schapel, and looks really
nice.

It certainly looks interesting, but I'm a little at sea on the subject of
how to integrate the XML with Access. That is, having downloaded the XML,
how to I tell Access to use it?

Dick

 

[Ken Snell \(MVP\)]

The free Chilkat FTP dll file is easy to use and doesn't involve XML per se.
I am using it as well in an ACCESS application that is automatically putting
backups of backend files onto a corporate FTP site for offsite
backup/recovery and for uploading data extracts nightly. Works well.

 

[news2]

OK, worked at it and got it going. Sorry for the distraction.

Indeed the Chilcat FTP (free) is great - works like a charm.

Dick

 

[Tony Toews [MVP]]

The free Chilkat FTP dll file is easy to use and doesn't involve XML per se.
I am using it as well in an ACCESS application that is automatically putting
backups of backend files onto a corporate FTP site for offsite
backup/recovery and for uploading data extracts nightly. Works well.

Hmmm, free, I like that. <smile>

Thanks, Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

Note that you can also do very simple FTP by using
a HyperLink in Access.

(david)

 

[Todos Menos [MSFT]]

FTP is built into SQL Server

you ****ing newbie kids should be shot

 

[Tony Toews [MVP]]

A a r o n K e m p f wrote:

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

Tony,

Thanks for being vigilant.

 

[Susie DBA [MSFT]]

Note that Tony Toews is a MDB _WUSS_ and should not be trusted for
anything.

It's like going to ask a 1st grader for financial advice


ADP uber alles!