Event Tracking Log

[cgshunter]

I need to know if there is a way to creat some type of tracking log that will show me who logs in to the database and when, plus, what has been changed. I have several users that are skilled in "shelling" out of the database and obtaining access to the forms, etc. I can't prove they are doing this unless I have some type of activity log.

Carl

 

[Parker]

I need to know if there is a way to creat some type of tracking log that will show me who logs in to the database and when, plus, what has been changed. I have several users that are skilled in "shelling" out of the database and obtaining access to the forms, etc. I can't prove they are doing this unless I have some type of activity log.

Carl

I'm sure there are some examples here somewhere of ways to log and record users.But also look here you may find something that will do the job

 

[arnie275]

I need to know if there is a way to creat some type of tracking log that will show me who logs in to the database and when, plus, what has been changed. I have several users that are skilled in "shelling" out of the database and obtaining access to the forms, etc. I can't prove they are doing this unless I have some type of activity log.

Carl

You may want to take a look at this thread:

http://www.access-programmers.co.uk/forums/showthread.php?t=46670&highlight=logon+form

They talk about some basic logging of User's in and out times. You may also want to Disable the Shift key to keep the users from getting around your security. Do a search on the forums and you should find lots of info.

 

[cgshunter]

Thanks

Thanks a million, nutter, genius............. whatever.

 

[ghudson]

Sounds like you need to secure your db using Access workgroups and permission's. I suggest you read and read again on how to setup Access security on your db. Ensure you make backup copies of your db before you attempt to implement Access security to your db.

You will not be able to track who is monkeying around with your data if the users are able to access the tables whether they do it directly or indirectly via queries and importing or linking to the data. Access security will prevent that if you set it up correctly.

Once the users are forced to use your forms to view/edit/add data then you can set up an audit trail to your tables. Here is an sample of how I do it... Audit Trail

 

[cgshunter]

Thanks!

Thanks a million Arnie!!!!!!!

You may want to take a look at this thread:

http://www.access-programmers.co.uk/forums/showthread.php?t=46670&highlight=logon+form

They talk about some basic logging of User's in and out times. You may also want to Disable the Shift key to keep the users from getting around your security. Do a search on the forums and you should find lots of info.