SharePoint with ACE OLEDB 12.0
In this article I will explain how to use SharePoint with ACE OLEDB 12.0
Introduction
SharePoint Assistant is a free Windows application that enables users to add functionality and spice up SharePoint pages without the need to involve IT.
Coding
Include "Provider=Microsoft.ACE.OLEDB.12.0" in the connection string to use this provider.
|
For Read and write
Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes; DATABASE=http://pp1webofficelivecom.officelive.com/Documents/;LIST={5999B8A0-0C2F-4D4D-9C5A-D7B146E49698};
|
Read only
Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=1;RetrieveIds=Yes; DATABASE=http://pp1webofficelivecom.officelive.com/Documents/;LIST={5999B8A0-0C2F-4D4D-9C5A-D7B146E49698};
|
Bridging to ACE OLEDB 12.0
Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes; DATABASE=http://pp1webofficelivecom.officelive.com/Documents/;LIST={5999B8A0-0C2F-4D4D-9C5A-D7B146E49698};
|
You may also want to read these related articles :
here
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answer here