Logging SQL Actions on MS ACCESS

[oLiVieR CheNeSoN]

Hi ,


I am using MSACCESS to read/write on SQL SVR.
Is there a way to log the actions performed on MSACCESS . ( DELETE, insert,
....) to trace what has been done on the SQL SVR using MSACCESs.


Thanks
Olivier

 

[Norman Yuan]

Your best bet is to use TRIGER on the target table to log any changes made.
As for only logging changes made by a particular MSAccess front-end, you
could have the MSAccess app use a given login and use CURRENTUSER function
in Triger's T-SQL code to test whether the change is caused by that login
and then do some accordingly.

 

[BJ Freeman]

SQL server has a Profiler. I can write to disk.

 

[oLiVieR CheNeSoN]

My problem is that I am not administrator of the SQL server , i am only
user.
My team is updating some tables by using SQL Query analyzer or MS access.
For MS Access, i want to keep track of the changes. Is there any events to
add in the MS ACcess db to log the queries ?

 

[NICO_bruneta]

cine esti?
asl