Thanks Jeff, that helps a lot. I'm reading your InsideOUT book right now. I just skipped ahead to the UserDisplayName() part. I couldn't get the example to work, but I'm guessing that is what I would use to build a change tracking part to the tables.
I was hoping Access would do the basic...
An Access Web App is published through SharePoint, so SharePoint takes care of authentication and rights to the database. You also get your Access back-end converted to SQL Server. A lot of this is automatic.
I have read Sharepoint adds fields to the Access Table to track "Updated By User"...
Does an Access 2016 Web App on SharePoint automatically support some sort of auditing? Some old Access 2010 posts seem to say yes, but when I connect to the SQL Azure database with Access, I don't seem the audit fields that they list.
Anyone have info on this?
I've been an Access programmer off & on for 20 years now, back in the days of 2.0 right out of college. I got away from it for a while and have been mostly a VB.NET / ASP.NET programmer (among 6 other things) for the last 10 years, but still use Access for a few things.
I've got a project...