Run query: Operation canceled by user

Hello, yesterday the execution query worked, and today for some reason it shows an error when executing access query. The database is linked sharepoint table. No changes were made to the sharepoint list. Maybe someone has any ideas what should I try? Actions with the local tables work, error only occurs with linked tables.

@Erikas_Martinaitis

Please increase the timeout…looks like the timeout has reached for the query

Cheers

It doesn’t wait for timeout, it automatically stops with the same error
image

@Erikas_Martinaitis

Run in debug and check the inner exception details by going to locals panel …it would have more info…that might be helptful

Cheers

The picture above is from inner exception, the problem is with database it says OleDbException but it doesn’t say anything useful that I would understand

The query is basic “SELECT * FROM [Reputacijos tikrinimas]” and the table looks like this

Seems like access database bug, I created an empty access file then linked the same tables and connected. After that the error was gone.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.