I have an Access 2010 front-end linked to a SQL Server 2008 back-end. The linked tables in the front-end use SQL login authentication (as opposed to Windows NT authentication). My question is what can I do with VBA to obtain the current SQL user that was authenticated for the current session?
I'm looking for something like Environ("UserName"), which gets me the current Windows user.