Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #12642

Providing credentials to Access at run time to connect with linked sharepoint lists

Show all headers | View raw

I am looking for a way to provide login credentials for SharePoint lists that are linked to by an Access front end.

Normally that is straightforward.

My issue is that I want to prevent the user from being able to access the sharepoint lists directly in Sharepoint.   Normally they would have that capability but I try to hide the lists in a subsite and tell them to never even try.

So my idea is to set permissions to the updated tables, now SharePoint lists to a unique user ID and then provide the credentials at run time of the Access FE so that the user who is authorized to run the Access front end can access the connected tables/lists but cannot do so without Access front end running.

And, of course, it would be great if the "scope" of that connection is limited to the Access program, so that the user could not just run the Access front end, connect to the sharepoint lists, then open up sharepoint via a browser and manipulate the lists.

Needed for the high security of this app.

Solution?

Bob

Back to comp.databases.ms-access | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Providing credentials to Access at run time to connect with linked sharepoint lists bobalston@gmail.com - 2017-06-26 21:17 -0700
  Re: Providing credentials to Access at run time to connect with linked sharepoint lists Ron Weiner <rw@domain.com> - 2017-06-27 10:05 -0400

csiph-web