Need info, books, articles,code, etc: Access VBA to XML to/from MySQL via HTTP



Hello everyone,

This is my first attempt at getting help in this manner. Please
forgive me if this is an inappropriate request.

I suddenly find myself in urgent need of instruction on how to
communicate with a MySQL database table on a web server, from inside
of my company's Access-VBA application. I know VBA pretty well but
have never before needed to do this HTTP/XML/MySQL type functions.

I need to be able to create new records, read from and update records
stored in a MySQL database on a web server FROM a client based Access
2003 application using VBA. The communication needs to be via HTTP or
HTTPS and the data can be transferred as XML. The table on the web
server is very simple. It has only 10 data fields with a single
column index.

Can any of you fine folks point me in the right direction for
self-tutorials in the form of sample code, articles, books, etc that
will help me learn to do these functions in the shortest possible
time. I'm sorry to admit that my job is on the line with this project.
I have been searching the web for this stuff but I am simply
overwhelmed with lots of loosely related items. Any help or guidance
will be very much appreciated.

--- Cheryl
.



Relevant Pages

  • [NEWS] Trend Micro InterScan VirusWall HTTP Proxy Content Scanning Circumvention
    ... Trend Micro InterScan VirusWall contains an HTTP proxy that prevents users ... from downloading virus-infected content by scanning the data received from ... a web server before passing it to the client. ... The Trend Micro InterScan VirusWall HTTP proxy contains a configuration ...
    (Securiteam)
  • RE: outlook and exchange
    ... Outlook using RPC over HTTP from the PC. ... Click To Do List and then click "Connect to the Internet". ... "Create a new Web server certificate", ...
    (microsoft.public.windows.server.sbs)
  • Re: Network Help
    ... > try to open an http: on the box, or on one of the other computers on ... > the network, it fails and has the network error: ... OR to not having any web server running on your box. ... 4- or..in a strange setup, you may have apache running from your inetd, ...
    (freebsd-questions)
  • Re: Network path name
    ... I apologize for wasting everyone's time with this issue. ... Or, if you are using http:, if the executable is in your default HTTP folder. ... without asking how the Web server finds the file. ... the program finds the configuration file OK. ...
    (microsoft.public.vc.mfc)
  • Re: http TRACE option
    ... Here's the HTTP TRACE discussion from the 2nd edition of my book ... If the TRACE method is supported and the web server is running a poorly written application that is vulnerable to cross-site scripting, a cross-site tracing attack can be launched to compromise user cookie and session information. ... If the web server is running a static site with no server-side application or processing of user data, the impact of TRACE support is significantly reduced. ... XST is an attack class developed by Jeremiah Grossman in 2003 that allows authentication details presented in HTTP headers to be compromised using a combination of XSS, client-side weaknesses, and support for the HTTP TRACE method server-side. ...
    (Pen-Test)