Access w/SQL Linked tables Slow/not responding started today

[isladogs]

Hi
I had downloaded a 32-bit version by mistake and deleted the sentence almost immediately when I realised.

Sorry but I don't have time to trawl the internet at the moment

 

[autoritat]

I had the same issue, among all the slowdown is huge in append querys from local table to the linked table on sql server or with querys between local access table and linked tables from sql server

I've installed ODBC Driver 17 and replace my actual odbc connection with a 17 version and, after a complicated day in my work, finally it works fine as before

Thanks for all your comments on the forum
Best regards

 

[cheekybuddha]

after a complicated day in my work, finally it works fine as before

Thanks for the feedback.

Why is everyone installing version 17 instead of 18?

 

[isladogs]

I can confirm the SQL driver slowdown has been fixed in the Current Channel.
You will just need to reopen Access for this to take effect. No version update required

 

[irade92]

I had the same issue, among all the slowdown is huge in append querys from local table to the linked table on sql server or with querys between local access table and linked tables from sql server

I've installed ODBC Driver 17 and replace my actual odbc connection with a 17 version and, after a complicated day in my work, finally it works fine as before

Thanks for all your comments on the forum
Best regards

Hi..I have the same problem, slowdown from local table to MySQL server, with querries... Any idea how to fasten it?

 

[autoritat]

Hi..I have the same problem, slowdown from local table to MySQL server, with querries... Any idea how to fasten it?

As the problem with the ODBC is solved those queries runs correctly as before. Nevertheless while i had the issue i solved partially changing the query first appending the server side table on another local table and exceute the query between just local tables

 

[irade92]

Hi..I have the same problem, slowdown from local table to MySQL server, with querries... Any idea how to fasten it?

As the problem with the ODBC is solved those queries runs correctly as before. Nevertheless while i had the issue i solved partially changing the query first appending the server side table on another local table and exceute the query between just local tables

let put it this way...I have three PC working on front end and adding some data to local tables and when they finished, they transfer the data into ODBC connected table in MySQL server..tranffering this data is slow. I use append query from local tables to ODBC linked table.