I am developing an application with a MS Access front end and a MS SharePoint back end. Currently a user must login twice to use the app, first login to the app and then into the SharePoint server.

I would like to remove this duplication by having the user only log into the server and using his/her server username to get the relevant info from my tblUser.

Sometimes the SharePoint username will be the windows username, but not always.

How do I get Access to “grab” the SharePoint username during the login procedure?