Tracking user visits to Access database

[honeypot3]

Hi there

I have a secured database which users have unique IDs to logon to use and I need to be able to record everytime a user logs on to the database so the information can be put into a report which counts the number of times they have accessed the database. It needs to record them just visiting not necessarily making any changes. I know CurrentUser() can be used but have no idea how I can get this information to be captured and stored in a table/query each time a user enters the database. Help would be appreciated.

Thanks Sandra

 

[honeypot3]

Please ignore this thread as have now found a simple solution

Sandra