ODBC from Access to SQL Server
Hello, Our Access ODBC to SQL server used to take 15 minutes to do a re-query (query button allows for 4 date ranges to be entered). It seems after the recent updates in both Windows and MS Office,...
Forum Discussion
lyeomans2160 So based off what you told me, I found two areas that could possibly help you out. Yes, absolutely try the new ODBC driver that you downloaded on a different client computer, which yielded great results.
Two: I'm assuming you're operating on Windows 10? I've read all sorts of performance issues expanding across many different pieces of software with the latest March 2020 update. If the ODBC driver does not increase the performance, I'd try uninstalling the latest updates of Windows. Not sure if that's the case but it's worth a mention.
Hello again,
Thank you for the suggestions. I went over and had a look at the SQL server. I discovered that Windows update attempt for SQL Server 2016 Service Pack 2 (kb4532097) failed to update.
I also notice in the ODBC window that the driver version is SQL Server 17. I know that 17.5 was released in March 2020. So I'm thinking if I get the service update Pack 2 to successfully install, update the ODBC Driver to 17.5 and update all the Access client ODBC drivers to 17.5 version, maybe things will work like they are supposed to.
Do you think it's worth a shot?
Thanks again!