I have been searching high and low on Google and finding very little information on using Web services with MS Access 2007. I'm sure this is possible somehow but I can't find any relevant information.
Any ideas?
+1
A:
Yeah, what has worked for me in the past is to build a com-callable .NET component, install it on the user's machine, and reference the COM-interface from the access database using VBA.
Steve
2010-07-22 17:53:28
That sounds like a lot of work! I'm not real familiar with .net, how much work would be involved in making some sort of "adapter" from my wsdl to a COM interface that I could use in Access? Is that a loaded question or what?!
Icode4food
2010-07-22 19:36:10
It's really not that much work, but if you're not familiar with .NET, a dll created with VB6 would work as well. Here's a decent article on calling a SOAP service from VB6: http://www.aspfree.com/c/a/VB.NET/Calling-a-Web-Service-using-VB6-with-SOAP-30/ you might even consider adapting the VB6 article to VBA.
Steve
2010-07-22 19:44:10
+1
A:
Have a look a Danny Delasandrini's article on consuming web services from Access. That should get you started, at least, (though it predates A2007 and A2010).
David-W-Fenton
2010-07-23 20:43:37