Multiusers in a workgroup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have about seven people going to use my database. Is there a way to
determine which user placed new entries into the database
 
Russ

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.

Good luck

Jeff Boyce
<Access MVP>
 
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
Click to expand...


**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
Back
Top