Create audit trail including username within Access Web Apps


Anyone an idea how to create audit trail including username within Access Web Apps?
Is this possible or is there some kind of workaround?

I refer to the older question

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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: - 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.
Thomas_VanderstappenAuthor Commented:
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.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
The macros are the same regardless, so you can use the macros in your web app. But, as I mentioned, I don't believe you can get the username in the web environment. You would have to create some sort of login system, and store the login names for that user/session, and then have the macro get the username from that table when creating the audit login.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Thomas_VanderstappenAuthor Commented:
Ok, thank you, but I was wondering if someone already has succeeded in implementing this and could guide me through?

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.