Connecting Access to a Web Service

[Guest]

Is there a easy straight forward way to connect an Access database to a Web
Service? For example I have a Web Service that returns a typed dataset, how
can I connect this directly to Access?

 

[Fred Boer]

Dear John A:

You will probably be interested in this:
http://blogs.msdn.com/clintcovingto...database-that-uses-amazon-s-web-services.aspx
and the follow-up...
http://blogs.msdn.com/clintcovingto...amazon-web-service-data-into-access-2007.aspx

I'm spending whatever spare time I can trying to teach myself about using
web services from within Access. You can obtain a Web Services Toolkit from
Microsoft...

http://msdn2.microsoft.com/en-us/library/aa192537(office.11).aspx

I think version 2.0 of the Toolkit is available from here:
http://www.microsoft.com/downloads/...0F-002A-4F5B-AF74-978F2CD6C798&displaylang=en
and version 2.01 here...
http://www.microsoft.com/downloads/...8A-E1CF-48A3-9B35-169D819ECF18&displaylang=en

I've read the following book:

Professional Development with Web APIs by Denise M. Gosnell.

It provides examples of using web services with Office programs.. I've been
able to make various personal demos work, but haven't as yet mastered the
process....

HTH
Fred Boer