Hi all,
I would like to ask a question regarding a connectivity issue that I have when trying to connect Blue Prism to an MS Access DB via OLEDB.
->Our goal is to select and update a SharePoint list via Blue Prism.
a) Due to the fact that we can't use the SharePoint APIs (due to permission restrictions of the SharePoint), I linked the SharePoint list to a MS Access database
b) Then using the OLEDB, I would select/update the MS Access database (that has the data of the SharePoint list) and then the changes will be finally pushed to the SharePoint list.
The problem:
Using the action stage 'Open' of Data - OLEDB VBO, I get an error 'Unrecognized database format'.
I read many threads online saying that sometimes the cause of this error comes from the compatibility of ACE and the version of MS Access. So, in order to identify is that was indeed my problem, I created an MS Access database having 1 table with 3 fields (added them manually) and I managed to connect, select and update the table. So, as it seems I have the correct ACE - MS Access way of connection.
This means that the problem occurs if I have an MS Access database that is linked with a SharePoint list, instead of having a local table with some local data, which would work.
My questions:
1) Have you ever faced something similar before?
2) Do you maybe have another idea of how to select/update a SharePoint List (except from SP APIs)
Setup details:
- MS Access 2013
- SharePoint Office 365 (2016)
- ACE 2007
- Connection string: "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\******.accdb;Persist Security Info=False;"
Thanks a lot in advance.
Konstantinos
