Integrate MS Access 2007 and SharePoint 2007 Server, Authentication and Authorization problems

[thomas]

Hi all,

We have a MS Access 2007 application and have integrated it with the
SharePoint Server 2007 which acts as the backend central storage.

When user opens the application, it displays a dialog for SharePoint
Account.
How to capture the SharePoint username programmatically so that we can
determine which record can be displayed and which forms can be used?

We have considered building another authentication process purely using MS
Access and VBA, but users will be required to go through two different
authentication processes by typing two pairs of username and password so as
to gain access to the SharePoint lists and the eligible database records and
forms.

Many Thanks
Tom

 

[Aaron_Lin]

Hi all,

We have a MS Access 2007 application and have integrated it with the
SharePoint Server 2007 which acts as the backend central storage.

When user opens the application, it displays a dialog for SharePoint
Account.
How to capture the SharePoint username programmatically so that we can
determine which record can be displayed and which forms can be used?

We have considered building another authentication process purely using MS
Access and VBA, but users will be required to go through two different
authentication processes by typing two pairs of username and password so
as to gain access to the SharePoint lists and the eligible database
records and forms.

Many Thanks
Tom

I don't know that....

 

[Larry Linson]

I don't know that....

No one here expects you to know the answer to every question. Everyone here
expects you to have the courtesy not to clutter the newsgroup by telling us
each one for which you do not know the answer. Thanks for your future
consideration.

Larry

 

[Tom Wickerath]

Hi Tom,

You can always use VBA code to capture the user's Windows login ID, which
you could store in a table, in SharePoint, to look up any other information
regarding that user.

Get Login name
http://www.mvps.org/access/api/api0008.htm


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[GBA]

Thomas - are you saying that when one opens the Access FE (located on one's
desktop) - that you are getting a sharepoint prompt just because the FE's
linked table resides on sharepoint?

 

[Thomas]

Yes GBA,

Since all the tables have been migrated to a SharePoint Server, when users
open the MS Access File, it prompts a dialog for SharePoint username and
password.
Once user is authenticated, the user can access to the tables and also the
forms.

The problem is that we have to ensure different individuals can only see and
change the database records that they are authorized to do so.

Therefore, we need to get the username of the authenticated user. The API
for getting windows username may not be applicable to this case since our
users are not part of our Windows LAN.

I was thinking to create different MS Access file and use "VIEW FORM" to
show necessary database records for each individual, but the application
performance is unacceptable and it requires me to maintain a number of MS
Access files for all the users.

Many thanks

Thomas