Web Services and Access

  • Thread starter Thread starter moondaddy
  • Start date Start date
M

moondaddy

Can Access send and recieve data via web services? I'm using MS Access
2003. If so, are there any examples and documentation?
 
Hi Moondaddy,

From your descriptions, I understood that you would like to exchange
information with web services. Have I understood you? If there is anything
I misunderstood, please feel free to let me know.

Based on my scope, The Microsoft Office XP Web Services Toolkit 2.0 brings
the power of XML Web services to Office XP by enabling developers to use
the Universal Description, Discovery, and Integration (UDDI) Business
Registry or the URL to a Web Services Description Language (WSDL) file to
reference XML Web services in Office XP solutions directly from within the
Visual Basic Editor.

More information could be found in the following sites

Document: Microsoft Office XP Web Services Toolkit
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnxpwst/htm
l/odc_wstoolkitoverview.asp

Download: Microsoft Office XP Web Services Toolkit 2.0
http://www.microsoft.com/downloads/details.aspx?FamilyId=4922060F-002A-4F5B-
AF74-978F2CD6C798&displaylang=en

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng
Microsoft Developer Community Support
 
In addition to Mingquing Cheng's advise elsewhere in this thread, as you're
using Access 2003, you'll want the Office 2003 version of the web services
toolkit ...

http://www.microsoft.com/downloads/...8a-e1cf-48a3-9b35-169d819ecf18&DisplayLang=en

Once you've installed the toolkit, you'll be able to add a reference to a
web service (in the VBA editor, select 'Web Service References ...' from the
'Tools' menu). The toolkit creates a VBA class that acts as a wrapper around
the web service, and you then call the methods of that class. An example
from one of my own apps ...

Set objPrimary = New clsws_primary
strXML = objPrimary.wsm_GetData(dtmMaxDate)
'Debug.Print strXML
Set objPrimary = Nothing

"clsws_primary" is the class created by the web services toolkit, and
"wsm_GetData" is a method of that class that returns a string containing
XML. All the code in "clsws_primary" was created by the toolkit when I added
the reference. The 'fun' part was the parsing and the translation between
XML as it is spoken by .NET, and XML as it is understood by ADO.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Hi Kevin,

It was not moved, I am not sure why you could access that web page. It
titled Microsoft Office XP Web Services Toolkit. May be you could follow
method below to get in

1. http://msdn.microsoft.com/library/default.asp
2. Expand Office Solutions Development
3. Expand Microsoft Office
4. Expand Microsoft Office XP
5. Expand Web Services Toolkits
6. That's It! Microsoft Office XP Web Services Toolkit

Thanks the input of MVP Brendan, he also shows the greatest answer, I
didn't notice your are using Office 2003. Here are the links for what's new
in Office 2003 Web Services Toolkit

Microsoft Office 2003 Web Services Toolkit
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnxpwst/htm
l/odc_wstoolkitoverview.asp

If you still could not view the pages, I would love to send them to you by
email.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng
Microsoft Developer Community Support
 
Back
Top