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 ?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Stored Procedures Criteria Reference to msAccess adp Form 1
inserting data from sql server to access 1
Can you Link a table in one DB to another DB's linked table? 1
Slow connection to Access 2007 2
Slow MDE Performance with MSAccess 2007 1
Using Access Database while Internet Users use DB simultaneously 11
SQL Server does not exist or access denied (after XP SP2) 1
MS Access 2007 ends unexpectetly - Calls VB6 DLL 6

Back
Top