Logging access to Access

[Minuet]

Can Access be set up to keep track of who accesses a particular database and when?

 

[Prophets]

You can create a user login form with username and password, before you load your next form, insert code to add a new record with login stamp in a log table.

 

[LittleSmudge]

Alternativly - use the built in Access security model which is a better 'security' approach and do the logging separately.


Set up your database to have a Form that always opens first ( the startup form ) and stays open throughout the life of the database ( you might 'like to' / 'need to' make it hidden - so the user doesn't see it - but keep it open )

In the On_Load event of this form write some code that stores logging data to a log table and then puts the log table record PrimeKey data in a control on this form.

Finally in the Form_UnLoad event add code to re-open the record and write the log off time.

The data I store in my tblBBISWY ( that's Big Brother IS Watching You )

Date and Time Log On
Network LogOnId
Id of Computer used to access the database
DataBase LogOnId
Date and Time LoggedOff


'ope-that-'elps.




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[MichaelRed]

If using Ms.A. Security (strongly advised), see faq181-291. it is a bit different, but logs all changes to the data where changed using bound forms.



MichaelRed
m.red@att.net

Searching for employment in all the wrong places