Need Access 2K3 VBA code for using WinInet functions

[Janet Wilson]

Can someone point me to some good instructions on using the
WinInet.dll functions from VBA?

I need to interact with a MySQL database via HTTP strings.
We already have the database set up and a PHP script that can receive
commands via HTTP. The script receives the HTTP commands and performs
the database actions, then responds with XML.

This system already works when I test it from IE. I simply send it an
HTTP string similar to this:

http://www.lmc.bz/tblAdvisories.php?username=UserNameHere&password=PwdHere&query=SELECT%20%2A%20FROM%20tblAdvisories%20WHERE%20contact_id%20%3D%2012

The PHP script executes the query and sends back the results in XML. I
just need to know how to set up the VBA code to send the requests. I
THINK I must use WinInet functions to do this. Am I correct, or is
there a simpler way to do it, perhaps using ADO?

More info is available if needed.

Thanks,

JW

[John Mishefske]

Yes I've done similar projects in Access and VB6 using WinInet. Here's a few leads from MS:

Platform SDK: Windows Internet - Using WinINet
http://msdn.microsoft.com/library/en-us/wininet/wininet/using_wininet.asp

WinInet: Enable HTTP Communication in Windows-Based Client Applications
http://msdn.microsoft.com/msdnmag/issues/01/06/UseMon/default.aspx

Platform SDK: Windows Internet - WinINet Reference
http://msdn.microsoft.com/library/en-us/wininet/wininet/wininet_reference.asp

Note that a few (less common) WinInet functions are only available if later versions of
Internet Explorer are installed on the client system - see:
INFO: WinInet APIs and Internet Explorer Version Information
http://support.microsoft.com/default.aspx?scid=KB;en-us;Q252369

How To Handle Proxy Authorization with WinInet
http://support.microsoft.com/kb/195650/EN-US/

--
'---------------
'John Mishefske
'---------------