Accessing focal point AXIS XML

[StefanOl]

Dear Sir or Madame


We have an application called focal point that use http/soap/xml interface

Is there a wonderful magic way to have ms access 2007 to connect
a xml API based database ?

ConnectToThisXMLServer(Http, User, Password)
​

And viola just everything starts to work, that is
ms access and the xml server talks to each other, exchange API's
setting up "sql tunnels", tables magical appear in ms access 2007 etc. etc.

Or I am a little bit to optimistic ?



Regards Stefan