Workgroup Benefits?

[Guest]

What are the benefits of creating and using workgroup? Is it possible to
tell who last updated a record if a workgroup exists?
Thanks for any advice,

 

[Allen Browne]

Workgroups are related to Access security. You don't need to bother with
them just to know who last updated a record.

Instead, use an API call like this one to get the name of the current user:
http://www.mvps.org/access/api/api0008.htm

Add a couple of fields to your table for storing the user name and date of
the last update, e.g.:
UpdatedBy Text
UpdatedOn Date/Time

Now in the BeforeUpdate event procedure of your form:
Me.UpdatedBy = fOSUserName()
Me.UpdatedOn = Now()

 

[Guest]

Great - Thanks - I'll try it. What else can I do to track activity?

 

[Allen Browne]

What else do you need to do, Tammy?

Personally I have those 2 fields in every table i create, plus 2 more that
track when/by whom the record was created.

If you want to track who visited each record, you could log that in the
Current event of the form.

If you want to track every insert, edit, and deletion, that involves using
several events, logging tables, temporary tables and so on, but it can be
done. See:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

 

[Guest]

Allen - I did what you in the before update event; inserted 2 columns in main
table and put in the code:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.Updatedby = fOSUserName()
Me.UpdatedOn = Now()
End Sub

And I keep getting a Compile Error: Sub or Function not defined. and the
word that starts with "f" is highlighted.

Tammy

 

[Douglas J. Steele]

Did you copy the code from http://www.mvps.org/access/api/api0008.htm into a
new module in your database like Allen said to?