I have a database which logs when a user opens the database and modifies certain things. The problem arises when another application connects to the database and changes the data that way.
We have 1 guy who uses excel to read data and modify data. I would like to be able to run code in the access database whenever this happens.
I have a splash screen which adds data to the log table but when the user accesses the data from excel, the splash screen event isn't triggered.
Are there any events I can add code to that would record when the excel user logs in?
Thanks for anyone who can point me in the right direction
We have 1 guy who uses excel to read data and modify data. I would like to be able to run code in the access database whenever this happens.
I have a splash screen which adds data to the log table but when the user accesses the data from excel, the splash screen event isn't triggered.
Are there any events I can add code to that would record when the excel user logs in?
Thanks for anyone who can point me in the right direction