The only good way to do this is to limit everyone who enters the
database to a menu system of forms that you have to set up - set up
forms with command buttons that open other forms. You can then attach
code to everything you want to log with event procedures in the
appropriate forms. It would be a lot of coding so you will have to
consider whether the work is worth what you get out of it. I've done a
similar thing where I've created a menu system users use to navigate
through a database so they only interact with forms and never see a
table or a datasheet directly. I keep the user name and the data/time
that names and addresses of clients are changed, but nothing like what
you are proposing. To have users log into your database, use the
Security options under Tools (I believe).
----- Original Message -----
From: Kung, M. Patricia <[log in to unmask]>
To: <[log in to unmask]>
Sent: Thursday, July 08, 1999 4:23 PM
Subject: [PCSOFT] Access question
> Is it possible to setup a way to keep a log of people who have gone
into the
> database and what functions they have preformed? We are on a network
and
> they have to log onto the network. Or can I create a sign in screen
for the
> database?
>
PCSOFT mailing list is brought to you by:
The NOSPIN Group, Inc.
http://nospin.com - http://nospin.org
|