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?

score 6 · Accepted Answer · answered Jul 09 '09 at 13:13

6

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.

answered Jul 09 '09 at 13:13

TheArtTrooper

1,105
8
19

Horray! That works!!! Gives a little too much information and too few options, but the data is there! – Eric Packwood Jul 09 '09 at 15:22

score 1 · Answer 2 · answered Jul 09 '09 at 12:55

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

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

score 1 · Answer 3 · edited Aug 20 '15 at 04:41

1

You might also find Jet SHOWPLAN useful:

https://web.archive.org/web/1/http://articles.techrepublic%2ecom%2ecom/5100-10878_11-5064388.html

edited Aug 20 '15 at 04:41

Community

1
1

answered Jul 13 '09 at 23:04

David-W-Fenton

22,871
4
45
58

+ but one downside is that the output file appears in the current folder, hence I have showplan.out files all over my file system (grr). – onedaywhen Jul 15 '09 at 09:38

Monitor queries in an access database

3 Answers3