Recording users using a DB

  • Thread starter Thread starter Neil Greenough
  • Start date Start date
N

Neil Greenough

Is there a way of recording the date and time users have used a database? My
DB is not password protected, but it is located on a network, with users
using their own 5-digit username and password to log onto the network.

Ideally, I would like a table created, listing the following columns:-

- User ID (5 digits)
- Date on (and time if possible)
- Date off (and time if possible)

From this, I then want to create a report and also a query to delete data
six or more months old.

Anybody willing to give a step by step guide for this?

Thanks
 
Ideally, I would like a table created, listing the following columns:-

- User ID (5 digits)
- Date on (and time if possible)
- Date off (and time if possible)
Click to expand...

Capturing the opening of a database is easy; you can use the Autoexec
macro to create an INSERT command to write the record. Google on these
groups for various more-or-less robust ways to get the user id from the
OS.

Date and time of closing is harder, because there is no Application event
for that. There are kludgy methods like keeping a hidden form open but
nothing robust.
From this, I then want to create a report and also a query to delete
data six or more months old.
Click to expand...

What help do you need with these?

HTH

Tim F
 
Back
Top