X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Access Fe Sharepoint Be Authentication Problem, SharePoint 2013    
post Nov 30 2017, 05:50 AM

Posts: 1,770
Joined: 14-March 00
From: Ayrshire, Scotland

Hi Folks

The difficulty is I can't seem to be able to allow Guests to connect Access to SharePoint lists.

Set up is:
Access 2016 FE with SharePoint (O365) lists as Back End.

All works fine with my O365 login and password.
However it doesn't work if I distribute the Access front end to the guest, having already invited them as a guest to the sub site containing the SharePoint list. The guest has gone through the process of accespting the invite but if they ope the Access FE and try to authenticate then Access freezes.
Go to the top of the page
post Nov 30 2017, 06:05 AM

Posts: 472
Joined: 25-November 14
From: Groningen, Netherlands

I presume, that's by design. You can share documents with guests, but you cant provide a guest access rights to a site collection imo.
What can't be done directly, can't be done indirectly with MS-Access, I presume.
Kind regards,
Go to the top of the page
post Nov 30 2017, 07:37 AM

Posts: 1,770
Joined: 14-March 00
From: Ayrshire, Scotland

Thanks Rob,

I tried a wee experiment which seems to work:

1. Created a VM with Windows 10, no Office Programs.
2. Installed my FE Access accdb and opened it
3. Signed in using a guest (Hotmail) account to which I'd already given permissions on the subsite

This works fine

Next steps r to re-create the problem:

4. Close the Access FE
5. Cleared all history in Edge. Closes all Edge tabs.
6. Signed into a recently created free Office 365 account (using a new username and password)
7. Opened Access and tried to sign in using the Hotmail account - no joy - cloced Access
8. Cleared all history in Edge.
9. Opened Access and used the newly created 'guest' authentication. Seems good

So it seems that if a user already has an O365 account we need to use that as authentication if they are Accessing an Access FE- SharePoint BE setup on someone else's O365
Hope this is accurate and helpful to others. I've only tested is one.
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    14th December 2018 - 04:50 PM