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?

On Thu, 20 Mar 2008 04:41:02 -0700 (PDT), Chu Gai
<(E-Mail Removed)> wrote:

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.


>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?