423,850 Members | 1,661 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,850 IT Pros & Developers. It's quick & easy.

Can MS Access display the user authentication that its backend SharePoint requires?

Stevan Bias
100+
P: 200
This question is similar to @twinnyfo's question here, I am trying to access a database that has some credentials requirements due to the backend SharePoint linked tables.

The database links to 6 tables that sit on SharePoint that uses a smartcard to verify access, specifically the card and pin. After you authenticate, the site becomes available. When you access the database without first logging into the SharePoint site, it freezes, which I assume is it waiting for some kind of credentials as it tries to authenticate to the SharePoint site.

The SharePoint site uses the same credentials the windows box used to login with, but it does not support using the authenticated session from windows, rather creates its own session with the same credentials.

My question: Can I call the user interface that SharePoint does to authenticate, so that the database does not first require the user to authenticate to the SharePoint site?
4 Weeks Ago #1

✓ answered by twinnyfo

Stevan,

I don’t know if this is an answer, but I have encountered similar problems when trying to save items to a SP library from Access. In order for the Access system to connect directly with SP Libraries, one must first connect to that library (i.e. simply go to that library via SP—or in my case, navigate to that library using WIndows Explorer to make the connection). Then Access can send items to that Library.

I would “think” that if the user was connected to that SP site and then opened the Access DB that things would work as expected. It’s an extra step, I know, but I think it has to do with how SP authenticates (and then times out) in connecting other system services to its libraries.

Again, don’t know if this is an “answer” or simply my workaround. SP must access the user’s system in some way to authenticate, I just don’t know enough about that aspect to speak intelligently about it.

Share this Question
Share on Google+
6 Replies


twinnyfo
Expert Mod 2.5K+
P: 2,704
Stevan,

I don’t know if this is an answer, but I have encountered similar problems when trying to save items to a SP library from Access. In order for the Access system to connect directly with SP Libraries, one must first connect to that library (i.e. simply go to that library via SP—or in my case, navigate to that library using WIndows Explorer to make the connection). Then Access can send items to that Library.

I would “think” that if the user was connected to that SP site and then opened the Access DB that things would work as expected. It’s an extra step, I know, but I think it has to do with how SP authenticates (and then times out) in connecting other system services to its libraries.

Again, don’t know if this is an “answer” or simply my workaround. SP must access the user’s system in some way to authenticate, I just don’t know enough about that aspect to speak intelligently about it.
3 Weeks Ago #2

Stevan Bias
100+
P: 200
Hey twinnyfo (hope all is well!)

Yeah, I came to the same conclusion. If the user opens the SP portal via a web browser first, there are no hiccups and the MS Database works as it should, obviously authenticating with the session credentials already initiated by the user. Although slightly annoying, it's not the worst work-around. What I would really like to explore is; force the MS Database to request user authentication in lieu of the SP portal page on open. But per our discussion, not really sure on how to approach it.
3 Weeks Ago #3

twinnyfo
Expert Mod 2.5K+
P: 2,704
I know I am way outside my wheelhouse, here, but even if you could access information in the Active Directory, listing all your authenticated users, I think you can only engage those protocols once you actually try to access SharePoint. It seems like a silly workaround, I know, to access the SharePoint page prior to the DB taking you there.

I look at it similarly to share drives (mainly because I use my SP libraries to save files (like a share drive). If I save something to my share drive, because all my users (and me) have permissions in AD on that drive/folder, I can save files there. "One would think" that trying to save something to SharePoint would work the same way if a user had permissions in AD for a particular SP Page/folder/library.

I understand what MS is trying to prevent, but in my opinion, permissions are permissions....

Sorry I can't be of more hepp!
3 Weeks Ago #4

Stevan Bias
100+
P: 200
Lol, it is all good.

Unfortunately my situation is even more complex. Although the SP uses the same smart card for creds, it doesn't use the same AD structure or accounts as the domain. It is a multi-domain SP. So I am in the "must open browser" first bucket... I tried programmatically opening the SP portal from the first form open in my DB (prior to any forms that query data); but it doesn't authenticate properly, and then the user manually has to refresh the login page and then they get the cred prompt. Didn't really make the work-around any easier.
3 Weeks Ago #5

twinnyfo
Expert Mod 2.5K+
P: 2,704
HAHAHAHAHAH!!!!

Sorry, I know it's really not funny!


HAHAHAHAHAHA!

You gotta love Microsoft!
3 Weeks Ago #6

Stevan Bias
100+
P: 200
Haha, well at least I can laugh with you! :)

Got to love it...
3 Weeks Ago #7

Post your reply

Sign in to post your reply or Sign up for a free account.