Audit Trail

[Lynn_AccessUser]

Wondering if anyone has implemented an audit trail with an adp frontend and a sql backend.

Thanks!!

 

[Kevin_S]

Hi Lynn,

I have not done this with an ADP front end but I have (currently do) use an audit trail with an mde/mdb front end - SQL Server 2000 be and it works quite well. The thread related to this is located here:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=44231&highlight=audit+trail

This should work the same with your front end. I use SQL Server roles in my front end that I bring in using SQL Pass-Through Queries which you can see referenced in my example on this thread.

HTH,
Kev