2014-07-11, 02:37 #1
Using SharePoint username in Access
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?
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!