Create audit trail including username within Access Web Apps

Thomas_Vanderstappen
Thomas_Vanderstappen used Ask the Experts™
on
Hi,

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
http://www.experts-exchange.com/questions/28008036/Track-changes-in-application-by-username-Access-2013-web-app.html

Kr,
Thomas
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014

Commented:
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.
Most Valuable Expert 2012
Top Expert 2014
Commented:
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.
Ok, thank you, but I was wondering if someone already has succeeded in implementing this and could guide me through?

Kr,
Thomas
Most Valuable Expert 2012
Top Expert 2014

Commented:
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial