Linked Tables in Access not found

Copper Contributor

Hi,

 

I have written a windows application showing Sharepoint 2016 data. For the connection to sharepoint data I use an AccessDB with linked tables. C# uses an OleDbConnection with connectionstring with property "Provider=Microsoft.ACE.OLEDB.16.0" to call the data. The application now worked perfectly for about 7 years. Now the linked tables are not found for users who use 

Microsoft - Office 365 ProPlus 365 (16.0.12527.20612) (this version belongs to Semi-Annual Enterprise Channel (Preview)). Only for these users the access fails.

Users with Microsoft - Office 365 ProPlus 365 (16.0.11929.20776) (belongs to Semi-Annual Enterprise Channel) do not have a problem, for them everything works fine. 

"normal" access tables in this access database are accessible.

When users open the accessdb and open any of the linked tables, it works fine. It seems, that there is no permission problem on sharepoint side, no spelling problem in the call of OleDBConnection.

So my question: Why do linked sharepoint lists are not found when calling them by C# connection?

Anyone here, who can help me?

 

Many thanks in advance,

 

Stefan

0 Replies