Tracking who uses a database

  • Thread starter Thread starter Judy Freed
  • Start date Start date
J

Judy Freed

Does anyone know if there is an easy way to automatically track, perhaps via
Novell login, who does anything to an MS access database? The situation is
that we have a database in "test" mode and a limited number of users have
been given access to it. They are supposed to be entering records, running
reports, etc.

I can tell if they are entering records (they are not) - obviously- by the
number of records in the tables. But if they are running reports, etc., I
would like to be able to know that - so I could be sure that the database is
indeed, being tested.

Any ideas? Thanks

Judy Freed
Systems Development
UNC Charlotte
 
Judy Freed said:
Does anyone know if there is an easy way to automatically track, perhaps via
Novell login, who does anything to an MS access database? The situation is
that we have a database in "test" mode and a limited number of users have
been given access to it. They are supposed to be entering records, running
reports, etc.
I can tell if they are entering records (they are not) - obviously- by the
number of records in the tables.
Click to expand...

There's a simple example at
ACC2000: How to Create an Audit Trail of Record Changes in a Form
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q197592

Audit Trail - Log changes at the record level at:
http://users.bigpond.net.au/abrowne1/AppAudit.html
The article addresses edits, inserts, and deletes for a form and
subform.

Modules: Maintain a history of changes
http://www.mvps.org/access/modules/mdl0021.htm
The History Table routine is designed to write history records that
track the changes made to fields in one or more tables.
But if they are running reports, etc., I
would like to be able to know that - so I could be sure that the database is
indeed, being tested.
Click to expand...

Also put a one line call to a subroutine in each form and reports
OnOpen event logging the userid, date/time and name of the form/report
object.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
The variable name for who is logged into the database is
"CurrentUser"
You could create a table "Users_Info" with the fields
CurrentUser
date and time of access
On entering the database a query could be run appending the
the current user and date and time to this new table
"Users_Info"

Jim
 
Back
Top