FTP Upload Module

[gisash1]

I desperately need MDB sample with FTP Upload module.
If anybody has this treasure, please let me know
Thank you very much in advance

 

[gisash1]

I know that, simply I couldn't find my post in the list first, and I thought it was a problem with my ISP connection. Just made a duplicate. Sorry. But it would be better if you helped me with my question, instead of teaching me how to post a thread.

 

[gisash1]

I wish you new the answer, let alone myself

 

[gisash1]

Actually, I have the same in Access 2000. But I need more specific thing. Some kind of form with controls which allow to browse ftp, delete, upload etc.
I found pretty good mdb sample with module which does those things. But it isn't free, as usual with good stuff.

 

[Wescotools]

Need MS Access FTP Module

Has any thing surfaced that will provide an upload function from a local file path to a prescribed ftp site.

Specifically I need a module to upload a file from a statically defined local file path to a statically defined ftp site.

Thanks for any help.

 

[SteveE]

Just in case anyone still wants this, this is how I ftp from access:
Create two files 1 a text file with your specific data in it:
1
create txt file ie ftpfile.txt as below with your specific details
===========================================
open
"your server"
"your server logon"
"your server password"
CD "to server location directory to store ftp file "ie /cluster/tmp/"
PWD
ascii
prompt
mput \\"stored location and full filename to upload"
bye

2
Create a bat file to do the ftp work i.e ftpmyfile.bat
===========================================
c:
cd \\"directory where your text file is stored"
ftp -s:\\"directory where your text file is stored"\ftpfile.txt
y
============================================

Then within your DB create a button which calls the shell function below
=================================================
Private Sub FTPFile_Click()
Call Shell("cmd.exe /c " & "\\"directory where bat file located"\myfile.bat", 1)
End Sub

works for me fine.

 

[gemma-the-husky]

steve

I am doing the same thing

I am executing my script with this command

Call ExecCmd("C:\WINdows\System32\ftp.exe -ns:" & infolder & "\" & scriptfile, vbMinimizedFocus)


(where infolder and scriptfile identify the ftp script)

this runs in a command window -
execcmd is a function that shells the ftp, but waits for it to finish before continuing - I can post this if you want it

BUT is there a way of getting it to run invisibly?

does your method show the command window, or does it run invisibly?

I would like it to run without displaying the cmd window (note that my vbminimisedfocus setting doesnt seem to do anything!)


Thanks

 

[SteveE]

The command just flashes up and goes off I have even had to remove the "bye" from the FTP text file to debug the process.

regrads

Steve

 

[gemma-the-husky]

ok

but it still opens the cmd window, and then closes

I am trying to get it to run without opening the command window (or maybe run with the command winmdow minimized)