Connecting Tech Pros Worldwide Help | Site Map

CAlling a web service from access

  #1  
Old November 12th, 2005, 07:52 PM
adolph
Guest
 
Posts: n/a
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calling Web service from VB6 with credentials =?Utf-8?B?SnVra2FU?= answers 0 May 28th, 2007 09:45 AM
call web service from pocket pc 2003 in VS 2005 pumaken68 answers 0 March 23rd, 2006 12:05 AM
Calling web service from ASP Sudha answers 1 November 23rd, 2005 06:33 AM
Calling web Service, from one error to another "Proxy Access Denied" into "The underlying connection was closed" lpinho answers 0 November 23rd, 2005 05:58 AM