Connection String to O365 SHP List

[MatoušKobilík]

Hello, we are using this connection string ( below ) to connect to o365 list and read/modify/insert data via BluePrism 6.9

Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=1;RetrieveIds=Yes;DATABASE=" + DatabaseURL + ";LIST={" + ListID + "};

After office was updated to 2108 build ( 14326.20738 ) It allows me only to read the data ONCE.. any other attempt gives me error "The microsoft access database engine could not find the object."

After i got this error i have to restart completely BluePrism and then it again works only ONCE ..

This is really weird, cause on office 2102 build there were no problems at all…

If everybody already experienced this behaviour please let me know what helped to resolve the issue

Thanks a lot

------------------------------
Matouš Kobilík
Application Manager
Československá obchodní banka, a. s.
Europe/Prague
------------------------------

[PabloSarabia]

Hi Matouš!

I think that the problem is not over your Blue Prism solution, sometimes the data base connectors from Access DB fails... I see this kind of problems many times when you install the Windows Updates or new Office updates.

I found this link https://support.microsoft.com/en-us/topic/office-365-microsoft-access-database-engine-could-not-find-the-object-f70da382-cb07-222d-a9dd-19f05466f353

In the article comment two possible solutions, try it.



Hope this solve the problem.

Bye 🙂

------------------------------
Pablo Sarabia
Programmer
Altamira AM
------------------------------