Connecting Tech Pros Worldwide Help | Site Map

CAlling a web service from access

 
LinkBack Thread Tools Search this Thread
  #1  
Old November 12th, 2005, 06:52 PM
adolph
Guest
 
Posts: n/a
Default CAlling a web service from access

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

 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,662 network members.