none
Object or Database read only error message when attempting to connect to xlsm file on sharepoint.

    Question

  • I need to combine spreadsheets (all that share the exact same column headers) into power pivot.

    I created a connection using these instructions http://blog.contextures.com/archives/2010/09/06/powerpivot-from-identical-excel-files/, but when I attempt to import the data into powerpivot I get an error message stating that I the object or db is readonly.

    This is what I have in the connection string.  (The mode WAS Share Deny Write, but I have since changed to READWRITE.  Still, no dice.)

    Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=C:\Users\zblumm\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.MSO\1CB9D4FB.xlsm;Mode=READWRITE;Extended Properties="HDR=YES;";Jet OLEDB:System database=;Jet OLEDB:Registry Path=;Jet OLEDB:Engine Type=37;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False;Jet OLEDB:Bypass UserInfo Validation=True;Password=**********;Jet OLEDB:Database Password=**********

    Any thoughts on how to get around this? 

    I have full permission on the file and the document store in sharepoint

    The file itself is not read only.

    Thanks,

    Melissa

    Wednesday, August 22, 2012 5:36 PM

Answers

All replies