This is an automated archive.
The original was posted on /r/sysadmin by /u/jwckauman on 2024-01-22 20:06:26+00:00.
Access Runtime hangs sometimes and not others (IIS, app pools, ASP.NET, Excel ODBC driver). Anyone have any experience using Access Database Engine in web apps hosted by IIS? My web app worked fine with Access Database Engine 2016 but works inconsistently when I upgrade to Access Runtime 2019 or Aceess Runtime 365. Sometimes the app works fine but other times it hangs without any explanation as to why. When it hangs, I can see the app pool and the w3wp process using a lot of resources. I also see a lot of wait states for that process. All the app does is open an Excel file provided by the user, read the names on the tabs of each sheet, and then displays the sheet names in a drop down list. The user can select a sheet name which the app will then read and display that sheets data on the page. It's just a simple Excel ODBC driver that is used (provided by the Access Runtime). Why would the app hang sometimes and not others? How can I troubleshoot?