Microsoft Access (2016) ALL Pass Thru queries to SQL Server 2017 suddenly (starting today) failing for about 15% of users. Rest of app is fine but when these particular users hit a pass thru they get ODBC All Failed ODBC Driver manager Invalid Cursor State (#0). All users on Windows 2010, ODBC 17, all same patch/update level of both Office and Windows. No changes to app and many of the sprocs are very simple such as passing one parameter to a SQL View to populate a now filtered form.
Nothing shows up in terms of patches, updates or difference form the majority that do work fine vs the ones now failing. Many of these pass thru queries have run for years. All other network functions are fine as is the rest of the app where sprocs are not called via the pass thru. Problem is strictly pass thru. 95% of the sprocs do not even use cursors.
This is a puzzle to me.