Re: Need help with using HTTP from VBA in Access 2003.

Hello, Lauren Wilson.

Please don't multipost the same question in three different newsgroups,
especially under different names, as the experts who answer questions are
likely to get angry when they find out you wasted their time because your
question has already been answered in another newsgroup. Please see the
following Web page:

http://www.mvps.org/access/netiquette.htm

Last time you were posting a similar question as Cheryl Langdon, who was
supposedly being helped out of a desperate family crisis, the application
was for a charity to tutor disadvantaged youth, yada, yada, yada. So who is
Janet supposed to be? A cousin from Georgia on her way to Hollywood to get
a job in the movies but needs gas money to get there, so she's working on
your software application for you to pay you back the money you've loaned
her?

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

You're passing the User ID and password as parameters in the URL to a
script? Do you realize what a security risk this is?

Am I correct, or is
there a simpler way to do it, perhaps using ADO?

Have you considered the Web Browser Active-X control?

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.


"Janet Wilson" <nospam@xxxxxxxxxx> wrote in message
news:3h9o52ts8vfikuhn0c522dv9q61l4mapp4@xxxxxxxxxx
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: 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 sending HTTP strings from Access VBA.
    ... 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.formscoding)
  • 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)