Logging queries against a .mdb

[Thomas Luzat]

Hi,

is there a way (possibly some 3rd-party tool?) to log queries (SELECT,
INSERT, UPDATE, DELETE) made against a .mdb by a .mde (no source available)?

Thanks in advance!

Thomas Luzat

[Tom van Stiphout]

On Tue, 22 May 2007 22:33:02 +0200, Thomas Luzat <th****@luzat.com>
wrote:

Not that I know of. Such low-level information just isn't available
in Access (better: Jet).

If you could somehow use an ODBC driver to access the back-end, it
would be able to log the calls (google for 'trace.log').

If you REALLY wanted to do this, you could replace your normal
back-end with one that has linked tables to SQL Server tables, and
then you could use SQL Server's tracing abilities to get close to what
you need.

-Tom.

>Hi,

is there a way (possibly some 3rd-party tool?) to log queries (SELECT,
INSERT, UPDATE, DELETE) made against a .mdb by a .mde (no source available)?

Thanks in advance!

Thomas Luzat