Add a field to your table(s). Store the user's name/initials in the field.
Add TWO fields. One is for "new" and one is for "changed".
Add FOUR fields. A pair for new (who and when), and a pair for last
changed.
In your forms (you ARE using forms, right, not entering directly in the
tables?!), add code behind the form in the BeforeUpdate event to fill these
additional fields.
You can probably find examples at mvps.org/access, or by using Google.com to
search.
In addition to Jeff's comments, if you have implemented User Level
Security on your database, then the CurrentUser() function will return
the name of the current, logged-in user. You can use that info to
populate the various fields of your table.
I have about seven people going to use my database. Is there a way to
determine which user placed new entries into the database
**********************
(e-mail address removed)
remove uppercase letters for true email http://www.geocities.com/jacksonmacd/ for info on MS Access security
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
