Tracking Users by Workgroup User ID

[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.

 

[Scott McDaniel]

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.

I'm not sure how you get the UserID, but if you've secured the database and are requiring logins, then the CurrentUser
function will return the currently logged-on user. From there you'd need an audit trial, and Allen Browne has a detailed
page on this:

http://allenbrowne.com/AppAudit.html

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[charles.kendricks]

I'm not sure how you get the UserID, but if you've secured the database and are requiring logins, then the CurrentUser
function will return the currently logged-on user. From there you'd need an audit trial, and Allen Browne has a detailed
page on this:

http://allenbrowne.com/AppAudit.html

Scott McDaniel
scott@takemeout_infotrakker.comwww.infotrakker.com

Thank You Scott...Your input gave all the information I needed...Being
a complete novice, I didn't even know about the CurrentUser function.
Thanks again.

Charles Kendricks

 

[Douglas J. Steele]

AFAIK, the API code in http://www.mvps.org/access/api/api0008.htm at "The
Access Web" will return the login for a workgroup setup as well.