Let me first state that I have used web services before, but only
through MS VS.NET and with using a WSDL for interface self
documentation.

I need to use web services to retrieve data from a new server
application and pull this data into MS Access. The web services
associated with the application do not use a WSDL and from my
understanding, the way you talk to it is by creating a XML soap message
with needed parameters and post that message to the web service and
then pick up the response.

My question is, how can this be done short of VBA? Are there any
software add on's available for Access 2003 to help in this process.
Are there any good links on the web that describe how to do this? Any
help with this venture would be greatly appreciated.

James Wallace

TexasAggie96 wrote:
> Let me first state that I have used web services before, but only
> through MS VS.NET and with using a WSDL for interface self
> documentation.
>
> I need to use web services to retrieve data from a new server
> application and pull this data into MS Access. The web services
> associated with the application do not use a WSDL and from my
> understanding, the way you talk to it is by creating a XML soap
> message with needed parameters and post that message to the web
> service and then pick up the response.
>
> My question is, how can this be done short of VBA? Are there any
> software add on's available for Access 2003 to help in this process.
> Are there any good links on the web that describe how to do this? Any
> help with this venture would be greatly appreciated.
>
> James Wallace

Without using VBA? No.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

You have to use VBA, but yes..there is a web (soap) tool kit add in for
a2003.


http://www.microsoft.com/office/prev...es/toolkit.asp

Take a look at the above screen shots, they are quite cool. You can see that
it is quite easy to use .net services in ms-office now.

http://msdn.microsoft.com/office/dow...s/default.aspx
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)