MS Access HTTP Post

[xollox]

I'm trying to post a zip file to a web server perl script. They say this about it:

The format of the post is a standard multiplart form post with 4 key/values:
username
password
data
client

I'm using MS Access 2002 SP1.

Any ideas?

Thanks.
-Chris

-XolloX

 

[xollox]

Forgot to mention, I need to retrieve the reply it gives too.



-XolloX

 

[xollox]

I was able to upload the file using a simple HTML page, but I need to automate this as well as retrieve the XML response it gives back. Any ideas on how to automate this? Automatically open the HTML page and submit it?

Thanks in advanced.

-XolloX

 

[psemianonymous]

I have a reference listed as "Microsoft WinHTTP Services, version 5.1" (winhttp.dll). I have no idea how to use it, but from looking at the classes/methods available, it looks like it will do everything you need. You may have to search to find/download it. Good luck.

 

[xollox]

Here is the HTML that I use to u/l the zip file. I looked into the WinHTTP services, but unfortunately I can't figure out if that'll work or not.

<FORM METHOD=&quot;Post&quot; enctype=&quot;multipart/form-data&quot; Action=&quot;whatever.asp&quot;>
Username<INPUT TYPE=&quot;Text&quot; Name=&quot;username&quot; value=&quot;&quot; size=&quot;20&quot;><br>
Password<INPUT TYPE=&quot;Text&quot; Name=&quot;password&quot; value=&quot;&quot; size=&quot;20&quot;><br>
File to upload<INPUT TYPE=&quot;file&quot; Name=&quot;data&quot; size=&quot;20&quot;><br>
Client type<INPUT TYPE=&quot;Text&quot; Name=&quot;client&quot; value=&quot;aui&quot; size=&quot;20&quot;><br>
<input type=&quot;submit&quot; value=&quot;Submit&quot;>
</form>

Any ideas?

-XolloX

 

[xollox]

getting closer and closer...

I can use this following line of code to do all but upload the file...anyone have any idea how to get this to u/l it? I'm trying to get it to upload the file &quot;whatever.zip&quot;

Application.FollowHyperlink UploadServer, , False, False, &quot;username=[un]&password=[pw]&data=c:\whatever.zip&client=aui&quot;, msoMethodPost

Thanks.

-XolloX