SOAP and Access

[totomalas]

I want to call a web service to update some tables in my Access database. I have been told i must use SOAP to call the webservice, but I couldnt figure out how to do it in Access....can you please help...

 

[Alisa]

You need to install the office web toolkit (I think it is version 2.0, but not sure). Then in your tools menu you will have an option for web services.

 

[totomalas]

You need to install the office web toolkit (I think it is version 2.0, but not sure). Then in your tools menu you will have an option for web services.

Ya I installed it, but when i try to access it from Tools.. it gives me an error that says that i need to have internet explorer that is 5.01 or above...and i am using windows Vista...!!!...how can i solve this?

 

[Alisa]

What version of IE are you using?

 

[totomalas]

What version of IE are you using?

I tried it on 7 and 8...and still the same result

 

[Alisa]

What version of the web toolkit are you using? Does it say that it is compatible with Vista in the requirements? I have only installed it on XP, so maybe there is a different version now.

 

[marlan]

Hello from 2012!
Does any one know if there is a way around this tool? like coding it myself?
How would one do that?

 

[ByteMyzer]

You can use the Microsoft.XMLHTTP object methods. Here's an example for retrieving a list of items from a SharePoint site:

[COLOR="Navy"]Public Sub[/COLOR] SoapExample()

[COLOR="navy"]Dim[/COLOR] objXML [COLOR="navy"]As Object[/COLOR], objList [COLOR="navy"]As Object[/COLOR], objItem [COLOR="navy"]As Object
Dim[/COLOR] vID [COLOR="navy"]As Variant[/COLOR], vTitle [COLOR="navy"]As Variant[/COLOR], vDefaultViewUrl [COLOR="navy"]As Variant

Set[/COLOR] objXML = CreateObject("Microsoft.XMLHTTP")
objXML.Open "POST", "http://MySharePointSite.com/sites/mysite/_vti_bin/Lists.asmx", [COLOR="navy"]False[/COLOR]
objXML.setRequestHeader "Content-type", "text/xml"

objXML.send "<?xml version=""1.0"" encoding=""utf-8""?>" _
    & "<soap:Envelope " _
        & "xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" " _
        & "xmlns:xsd=""http://www.w3.org/2001/XMLSchema"" " _
        & "xmlns:soap=""http://schemas.xmlsoap.org/soap/envelope/"">" _
        & "<soap:Body>" _
            & "<GetListCollection " _
                & "xmlns=""http://schemas.microsoft.com/sharepoint/soap/"" />" _
        & "</soap:Body>" _
    & "</soap:Envelope>"

[COLOR="navy"]Set[/COLOR] objList = objXML.responseXML.SelectNodes("//List")

[COLOR="navy"]For Each[/COLOR] objItem [COLOR="navy"]In[/COLOR] objList
    vID = objItem.GetAttribute("ID")
    vTitle = objItem.GetAttribute("Title")
    vDefaultViewUrl = objItem.GetAttribute("DefaultViewUrl")
    [COLOR="navy"]Debug[/COLOR].[COLOR="navy"]Print[/COLOR] vID, vTitle, vDefaultViewUrl
[COLOR="navy"]Next[/COLOR] objItem
[COLOR="navy"]Set[/COLOR] objXML = [COLOR="navy"]Nothing

End Sub[/COLOR]