none
oleDB Access to Sharpoint Lists

    Question

  • Good Day to you all,

    I'm running into a problem with a lightly and maybe undocumented feature of Sharepoint...

    I'm using the following connection string to gain access to SharePoint lists:

    Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes; DATABASE=http://pp1webofficelivecom.officelive.com/Documents/;LIST={5999B8A0-0C2F-4D4D-9C5A-D7B146E49698};


    Everything works perfectly except we are unable in insert new items into the list,with a simple "INSERT INTO" query.  Our first thought was a security issue, and we verified it was not.  We set the Data Retrieval Service-Enable Update query support.  We can modify existing records, and I can delete all records with a "DELETE * FROM LIST", but no creation of new records.

    Does anyone have any thoughts?

    Thanks!
    Rich


    Thursday, January 15, 2009 2:48 PM

All replies