Access 2003 Login Question

C

Chu Gai

I've got a database that's usually used by two people simultaneously.
I'd like to be able to implement a means by which I can track which
person is responsible for having entered a particular record. Like
being able to store their name, or a reference to it, in the relevant
table. This is so I can determine if the occasional errors that come
up from time to time are traceable to a particular person. Any idea
how I can pull this off?
 
T

Tom van Stiphout

On Thu, 20 Mar 2008 04:41:02 -0700 (PDT), Chu Gai

I would NOT use Workgroup Security for this, because it is an advanced
topic. Rather I would ask Windows who the logged-in user is. Code is
here: http://www.mvps.org/access/api/api0008.htm
Then add a field to the table, and write this value to it.

-Tom.
 
Top