C
charles.kendricks
I have a split database consisting of the front end residing on an XP
desktop and the backend on a server running Server 2003 R2, and not
utilizing a domain controller. The necessary tables are simply linked
to the frontend from the server. If I secure the database with the
Workgroup Administrator and issue each user his own User ID, how can I
then track or audit which user makes specific changes and/or updates
to the database and when they are made. I specifically want to know
which user adds which records to the database.
desktop and the backend on a server running Server 2003 R2, and not
utilizing a domain controller. The necessary tables are simply linked
to the frontend from the server. If I secure the database with the
Workgroup Administrator and issue each user his own User ID, how can I
then track or audit which user makes specific changes and/or updates
to the database and when they are made. I specifically want to know
which user adds which records to the database.