Afternoon - its has been a long while since i have been asked to do anything that required any outside help but this task is drivign me up the wall and wondering if anyone has any insight.
Setting: Access 2016 as a front end using sharepoint lists as tables. Nothing to crazy so well within spec. Any DB i create and link to sharepoint is fine whichever way way i link (create or link to existing). The problem comes from someone else trying to access the lists from access - it wants to log on as me??!?
i have tried everything.
Some of us are remote working and using a VPN which i thought my be causing issue - but no - same issue for people in the office.
i got my IT to create a full SP site where i was owner and the other people i set up as owners.... no luck
I have created loads of different user groups on SP - no luck
from what i can see it should work... a simple linked list/table from Access but nobody other than the creator can access the lists....fustrating
I have a lot of Access solutions i need to move data to SP before i can start coding PowerApps replacements (will miss Access but still got it at home so all good)
Has anyone had this issue? or at least heard of it and its solution?
if i can provide any more info - let me know. here's hoping!
Setting: Access 2016 as a front end using sharepoint lists as tables. Nothing to crazy so well within spec. Any DB i create and link to sharepoint is fine whichever way way i link (create or link to existing). The problem comes from someone else trying to access the lists from access - it wants to log on as me??!?
i have tried everything.
Some of us are remote working and using a VPN which i thought my be causing issue - but no - same issue for people in the office.
i got my IT to create a full SP site where i was owner and the other people i set up as owners.... no luck
I have created loads of different user groups on SP - no luck
from what i can see it should work... a simple linked list/table from Access but nobody other than the creator can access the lists....fustrating
I have a lot of Access solutions i need to move data to SP before i can start coding PowerApps replacements (will miss Access but still got it at home so all good)
Has anyone had this issue? or at least heard of it and its solution?
if i can provide any more info - let me know. here's hoping!