Question Microsoft Access 2013 Web APP- Audit trail, how to grab logged in sharepoint user fro (1 Viewer)

BabaTana

New member
Local time
Today, 11:30
Joined
Sep 26, 2013
Messages
7
I have an access 2013 web app where i implemented audit trail to track changes and deletes and inserts on key tables.

I am using the table level data Macro. On Insert, On delete and On Update.

How do i grab the sharepoint user deleting or inserting the data. I notice that userDisplayName() function is not available at this level. Is there an easy way to pass the logged in user to these macros....
 

BabaTana

New member
Local time
Today, 11:30
Joined
Sep 26, 2013
Messages
7
I found a way around this...
1. i created last updated by field on all key tables
2.When creating a new record i sent the logged in user
3. when record is updated i save the last person to update it.
4. on the delete action bar i first update the last updated by field
5. then on the data macros for on insert, on udate, and on delete which i am using for audit trail i grab the changed by or created by or deleted by from this last updated by field

IT WORKS FINE THAT WAY.....
 

drjedi

New member
Local time
Today, 04:30
Joined
Mar 2, 2011
Messages
2
BabaTana:

Could you describe in more detail as to how you captured logged in username for auditing your tables? I am trying the same thing by having CreatedBy, ModifiedBy fields in each table, but not sure how to fill them with currently logged in username in an Access 2013 web app using data macros.

Much thanks

JD
 

ThomasVDS

New member
Local time
Today, 10:30
Joined
Jan 6, 2016
Messages
4
Hi,

I am also trying to include the username in the audit trail but without success...

Someone has an idea or can explain more in detail the workaround of BabaTana?

Thank you!

Kr,
Thomas
 

Users who are viewing this thread

Top Bottom