Need help with sending HTTP strings from Access VBA.

[Charles 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.myweb.com/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.

[Doug Robbins - Word MVP]

Maybe better to ask in one of the Access newsgroups, maybe
microsoft.public.access.internet, but that may not be the most appropriate.
I suggest that you browse through the Access newsgroups to try and determine
which would be the best one for your question or post to a number of the
most likely ones by inserting all of the addressess into the address control
of a single message.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Charles Wilson" <dontse...@fake.com> wrote in message
news:72ao52ljs6mcahbb6...@4ax.com...

[Jezebel]

It works the same way using the Inet control: use that entire string as the
'address', and you'll get back whatever the script at the end sends as the
page content.

"Charles Wilson" <dontse...@fake.com> wrote in message
news:72ao52ljs6mcahbb6...@4ax.com...