Discovering Which SQL Statements Are running in Access

[Manu Singhal]

Hi


I want to know which sql statements are running in my access database. Is
there any tool like SQL server profiler form which i can get information
about actions performed in the database.


I have an application which is modifying my database on doing some work. I
want to know which tables have been modified. ie. which sql statemets ran on
my database.


please help.!!


Manu Singhal
isoft solutions

 

[Douglas J Steele]

There's nothing built into Access that can do this, but Total Access
Analyzer, from FMS, is capable of providing this analysis and much more.

http://www.fmsinc.com/products/analyzer/index.html