zoqanu.blogg.se

Begin the Captureīefore we start capturing, we want to make sure that all existing instances of Microsoft Access are closed. The Filter dialog should look like this when you're done:Ĭlick to close the dialog. Enter "TraceSQLMode" in the third dropdown.Choose "ends with" from the second dropdown.We could have done this at the beginning when procmon first started up, but I wanted to show you how to get back to the filter once the program is running. We'll start by finding the TraceSQLMode value because it's the easier one to locate.Ĭlick the Filter icon so we can add another filter: Toggle the other four buttons OFF to reduce noise.īefore we start capturing again, we are going to add a couple of more filters. Toggle the far left button ON to capture registry activity. The key to making procmon a useful tool is to remove as much noise as possible from its event capture log. Leave the Registry Activity button toggled ON (it's the one on the far left). We're only interested in the registry for this scenario. There are five toggle buttons on the far right of the toolbar. Disable event capture (1) then clear the display (2). We're not quite ready for that yet, so toggle off the Capture button then clear the event log. 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.