Access 2003 and SharePoint via DoCmd.Datatransfer

m2009 · May 19th, 2009, 07:00 AM

Hi,

An example:

<Query>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
<Parameters>
<Parameter Name="listName">
<DefaultValue>{1120AF7E-E607-4BC5-8BBE-FD9870B5337E}</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath IgnoreNamespaces="True">*</ElementPath>
</Query>

That run on SQL Reporting Service tools which works great. I want this result to work on MS Access 2003 via linked table.On MS Access 2003, is it possible to get the web service function called "GetListItems" via DoCmd.TransferDatabase (using acLInk)? Thanks.Regards,m2009

mmcdonal · May 27th, 2009, 10:44 AM

I can't answer that question, but what I have done is to create a view in the SharePoint content database with my list data, and then use ADO to connect to the SQL Server and retrieve the view. I find this method gives me greater control. If you are interested in that solution, I can help you there.