Due system Microsoft updates for Windows 7 and 10 in October 2017 PAS fails

to export data to Excel files.




To solve the issue follow next steps:

1) Unzip the archive to any this folder on your PC

ODBC access error -5016 fix

2) Open Command Prompt as Administrator.

3) Go to the folder, where the files where extracted

4) Run ‘Fix.bat’ to fix the problem. Check that the problem was fixed.


Note: Do not run fix.bat in Windows Explorer. 

It must be ran only in Command Line Console. 

Navigate to appropriate directory by command cd.


See example in the print screen below.




Additional Info -> Full Error description in ASP.NET application:

ODBC Excel Driver Stopped Working with "Unexpected error from external database Driver. (Microsoft JET Database Engine)".

ERROR [HY000] [Microsoft][ODBC Excel Driver] Reserved error (-5016); there is no message for this error. ERROR [01000] [Microsoft][ODBC Excel Driver]General Warning Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x1644 Thread 0x3e70 DBC 0x4c51fc4 Excel'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [01000] [Microsoft][ODBC Excel Driver]General Warning Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x1644 Thread 0x3e70 DBC 0x4c51fc4 Excel'. ERROR [HY000] [Microsoft][ODBC Excel Driver] Reserved error (-5016); there is no message for this error.