Need Access 2K3 VBA code for using WinInet functions

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
.

Relevant Pages

  • Re: Need help with using HTTP from VBA in Access 2003.
    ... Please don't multipost the same question in three different newsgroups, ... I need to interact with a MySQL database via HTTP strings. ... The PHP script executes the query and sends back the results in XML. ...
    (microsoft.public.access.forms)
  • Re: Re: Need help with using HTTP from VBA in Access 2003.
    ... was for a charity to tutor disadvantaged youth, yada, yada, yada. ... I need to interact with a MySQL database via HTTP strings. ... The PHP script executes the query and sends back the results in XML. ...
    (microsoft.public.access.forms)
  • Re: Need help with sending HTTP strings from Access VBA.
    ... This question has already been answered in another Access newsgroup. ... I need to interact with a MySQL database via HTTP strings. ... The PHP script executes the query and sends back the results in XML. ...
    (microsoft.public.access.formscoding)
  • Re: Need help with sending HTTP strings from Access VBA
    ... This question has already been answered in another Access newsgroup. ... I need to interact with a MySQL database via HTTP strings. ... The PHP script executes the query and sends back the results in XML. ...
    (comp.databases.ms-access)
  • Need help with using HTTP from VBA in Access 2003.
    ... WinInet.dll functions from VBA? ... I need to interact with a MySQL database via HTTP strings. ... The PHP script executes the query and sends back the results in XML. ...
    (microsoft.public.access.forms)
Loading