I have created a database and password protected it using various users and permissions. Is it possible to keep track of who logged in and what they used.
I have created a database and password protected it using various users and permissions. Is it possible to keep track of who logged in and what they used.
Hi,
the classic way to do this is to create a login table with user name and date/time of the login and put a code in the login form that automatically adds a record to this table with each new login.
Then add to each data table the fields: CreatedBy; CreatedOn; LastUpdatedBy and LastUpdatedOn, and put some code in your forms to automatically fill/update these fields. If you want to track deletions you can either create a "Deleted" table with info about who deleted what from what table at which time, or keep the records in the database and give them a "Deleted" status so they don't appear anymore in the result sets.
greetings,
NG
There are a couple of examples of this in the code repository.
Are there any samples available?
If there are could you please guide for the link to download the sample
Hi
Thanks for your reply this is exactly what I was looking for.I have downloaded the sample you attached but being new to access at the moment find it difficult to understand how to set it up in my database. Is there any step by step tutorial i could use to help me, or could I import the sample into the database and use it.
Again thanks for your help and any further help you can give me would be appreciated.
Thanks and regards
Mike
Hi
Not sure what I have done can you help?
Downloaded a sample named "QueryWithAForm" which I got from one of your links. I hoped this would help me create my Login tracking part of my DataBase. When I opened the query it gave my name as logged in and the date/time. Not sure how this got linked to my Database but it worked so OK I would try it. However when I logged on as someone else it still gave my name.
This all happened by me just playing around but now I,m curious to how it worked and how to change it to show correct username.
Regards mike
Mike
which sample data base have you downloaded.
Can you please provide the link
https://www.accessforums.net/code-repository/
this is the link I went to, it has loads of samples