Re: Logging queries against a .mdb

On Tue, 22 May 2007 22:33:02 +0200, Thomas Luzat <thomas@xxxxxxxxx>
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

.

Relevant Pages

  • Re: Pros and Cons of SQL v/s MDB
    ... do you know of a backup system that can be ... >that can have over 100 users on the same back-end. ... >Now, up-sizing to SQL server is often, bu not always the ... >>After the last corruption, which was recovered by ...
    (microsoft.public.access.adp.sqlserver)
  • Re: A97 to SQL?
    ... You could migrate your data to a SQL-Server back-end, and link to your data there. ... You might have to redevelop portions of your front-end to work better with SQL-Server data. ... I am starting to wonder whether the time has come to move to something bigger, like SQL server. ... Currently I am regularly adding little enhancements, new reports, etc etc, to the A97 mdb FE, and it's very useful that I can do this. ...
    (microsoft.public.access.conversion)
  • Re: Damn you, FEDEX! or Nikon D40 lost in Springfield, MO blackhole.
    ... the 2 mp Mavica he had been using with a Nikon D40. ... After shopping around, he got me to order one for him. ... The shipper had it insured, but from what I have read it could take weeks to sort this crap out. ... You may get your insurance from FedEx and a couple weeks later they find it and deliver it. ...
    (alt.photography)
  • Re: SQL Server 200 Developer vs Enterprise versions
    ... cannot overcome these we will revert to Access back-end. ... the licenses will be acquired for Enterprise ... to an SQL Server back-end. ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Pros and Cons of SQL v/s MDB
    ... With 20 to 30 users at its peak, Access with a shared JET back-end is not ... a SQL Server back-end can be a good option. ... and run periodic queries to update the OLAP system. ...
    (microsoft.public.access.adp.sqlserver)