When you click, procmon will immediately start capturing. To do this, we set up a Process Name filter and Include msaccess.exe: Start by resetting the filters (1), then choose 'Process Name' (2), enter msaccess.exe (3), click (4), then click (5). The first step is to show only the activities from Microsoft Access. Process Monitor is my favorite tool in the comprehensively excellent SysInternals suite from Mark Russinovich.Īs the name implies, it monitors Windows processes and logs all of their interactions with: Let me show you a foolproof way to discover the correct registry keys. There are plenty of articles that will show you how to set these values, but sometimes it just doesn't want to work for your environment.

And finding the correct registry keys can be tricky, since they depend on the bitness of VBA, the Access version, Click-To-Run vs. JetShowPlan and ODBC TraceSQLMode are two powerful query analysis tools for Microsoft Access.īoth of these tools must be enabled from the Windows registry.

Process monitor boot logging