Menu
Is there a way to monitor queries in an access database, similar to the way SQL Profiler works?
I have a very old piece of software that I do not have the source for and it has an ODBC connection to an access database on another computer. Is there a way to monitor what queries are being called?
714
To view the SQL code for an Access query, open the query in query design view. Then click the “View” drop-down button in the “Results” button group on the “Design” tab of the “Query Tools” contextual tab in the Ribbon. From the drop-down menu of choices that appears, select the “SQL View” command.
To see the query results, on the Design tab, click Run. Access displays the results of your query in Datasheet view. To make further changes to the query, click Home > View > Design View to switch back to Design view.
The Performance Analyzer looks at the structure of the database as well as the data, and makes recommendations to help you improve performance and prevent confusing data errors.
The Table Analyzer Wizard can automatically analyze a nonrelational database and "normalize" it for you. Normalization is the process of taking a single-table database and breaking it into a set of smaller, related tables, with each table focused on a single topic or grouping of information.
Have you tried turning on the ODBC trace function? Use the ODBC Data Sources control panel applet. Switch to the 'Trace' tab and review the options available.
72
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
