Create audit trail including username within Access Web Apps

You can use DataMacros to record much of this, but I'm not sure about the UserName.

Scott Diamond has a writeup on his blog about this: https://scottgem.wordpress.com/tag/microsoft-access/ - see the post titled "Audit Trail using Data Macros"

You could perhaps stored the name of the user in a table somewhere, and then refer to that from those Data Macros. Of course, this assumes that you're "logging in" those users in your app.

Hi Scott,

Thank you for your answer.

I have taken a look at Scott Diamond's blog and his post is written for Access desktop version and not for web apps.
So, I am still stuck on this one.

Ok, thank you, but I was wondering if someone already has succeeded in implementing this and could guide me through?

Kr,
Thomas

I've looked into this, and there does not seem to be a way to get the username from a web app. This appears to be a limitation of Access.