Monitor queries in an access database

Question

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?

Answer 1

I do not know of a tool that does that - but I can suggest two simple ways of doing this:

1. Set-up a proxy so that your queries go to the proxy, the proxy logs them and then forwards them to the access database
2. do a tcp-dump and extract the queries (monitor what happens at the wire level).

Answer 2

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.

Answer 3

You might also find Jet SHOWPLAN useful:

http://articles.techrepublic.com.com/5100-10878_11-5064388.html