Need help with using HTTP from VBA in Access 2003.
- From: Janet Wilson <nospam@xxxxxxxxxx>
- Date: Fri, 05 May 2006 23:30:49 -0500
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
.
- Follow-Ups:
- Re: Need help with using HTTP from VBA in Access 2003.
- From: '69 Camaro
- Re: Need help with using HTTP from VBA in Access 2003.
- From: Arvin Meyer [MVP]
- Re: Need help with using HTTP from VBA in Access 2003.
- Prev by Date: Re: INserting Calculated Fields into Tables
- Next by Date: Re: blinking text
- Previous by thread: Re: INserting Calculated Fields into Tables
- Next by thread: Re: Need help with using HTTP from VBA in Access 2003.
- Index(es):
Relevant Pages
|
