Upload File From Access

[RobDog888]

I need to provide a function in an Access 2000 db that will take a textfile (queryresults in a specialized format) and upload/transfer it to a remote server over the internet. Never used windsock so not sure if its the right tool for the function but I think redirecting a command window's FTP session would work.

So which method sounds best and easiest for the function?

Thanks

[tommygrayson]

I don't know about FTP but I can help you if its in HTTP.

[RobDog888]

On the remote server there will be a folder where I need to upload these files (small text files 250bytes - 1k) periodically. The receiveing folder will have a filesystem watcher on it scheduled interval of 30 minutes where it will process any files in the folder and remove them after processing.

HTTP would be like a POST I assume but there will be authentication needed before the upload will be accepted.

[tommygrayson]

On the remote server there will be a folder where I need to upload these files (small text files 250bytes - 1k) periodically. The receiveing folder will have a filesystem watcher on it scheduled interval of 30 minutes where it will process any files in the folder and remove them after processing.

HTTP would be like a POST I assume but there will be authentication needed before the upload will be accepted.

Where would the files come from? Is it from the client machine or the remote server will generate the text files?

And where would the files go to? Is it from the client machine or the remote server?

[RobDog888]

They will be generated on the client machine from within an Access db. The textfiles will go from client machine to the remote server.

[RobDog888]

I was initially looking at using code like this but wanted to check out windsock first before integrating it all.

FTP API code example

[tommygrayson]

They will be generated on the client machine from within an Access db. The textfiles will go from client machine to the remote server.

So you are saying that the client machine will generate textfiles from their Access DBs and upload their textfiles to the remote server?

Is this process unmanned or automated or they will have to upload their own textfiles?

[RobDog888]

Correct, the process is to generate an Access report and when printed will generate the textfile(s) and automatically transmit the text file(s). Upon sucessful transmission, delete the textfile(s).

[tommygrayson]

Correct, the process is to generate an Access report and when printed will generate the textfile(s) and automatically transmit the text file(s). Upon sucessful transmission, delete the textfile(s).

Well you have to create 2 programs.

1 for the client that will process the Access Database to textfile.

1 for the Server that will look for active connection from the client.

Have you created the two programs so far?

[RobDog888]

The server part is already a completed provided service.

I just need to concentrate on the actual transmission of the file. I have everything else in place.

So upon the print event I need to transmit the file.

[tommygrayson]

In Winsock, you must have direct access to the client computer.

If you already have then do this on the client side:

Winsock.RemoteHost = 'Server Name
Winsock.RemotePort = 'Port Number
Winsock.Connect

[RobDog888]

When you say direct access will it make a difference if the client computer is a Windows NT 4 Terminal Server? It could be considered not direct.

But what I really want to know is which method is best and most reliable - FTP APIs or Windsock?