Logging SQL Actions on MS ACCESS

  • Thread starter Thread starter oLiVieR CheNeSoN
  • Start date Start date
O

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
 
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.
 
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 ?
 
Back
Top