Connecting Tech Pros Worldwide Help | Site Map

CAlling a web service from access

adolph
Guest
 
Posts: n/a
#1: Nov 12 '05
Does anyone know of or have VB code in access that can send XML to a
web service in the internet and then wait for a response?

I want to upload data from an MSaccess database to a PHP/MySQL web
site. I don't want to use an ODBC directly into the database. What I
would like to do is either send the data updates via XML to the
website, have the website PHP process the updates and then return
response telling the MSAccess code whether the update was successful
or not.

Another way would be to FTP the updates in the form of a delimited
text or XML file, then call a web service telling the web that new
data has been put on the web server and needs to be processed. But
how does the web server send a message back informing the msaccess
program that it was successful.

All I want the user to do is click on a button "Update website" then
wait for a popup message box saying whether the update was successful
or not.

Thanks in advance,
Adolph
Closed Thread