Question Access Front End, Sharepoint back end

[cdoyle]

Hi,

We are using sharepoint as our backend, and using Access (2007) for our front end.

In sharepoint I have certain fields in our lists hidden to users who view via the browser. The access front end is for the admins, and more of the fields are viewable using Access.

What is a good method to adding a password on the Front End to stop anyone from using it, to view the other data?

Thanks,

 

[boblarson]

Don't you have security set up on the SharePoint site for who can view what. Those permissions SHOULD come through the frontend as well (that is one reason why Microsoft was pushing SharePoint and Access as opposed to User Level Security in Access).

 

[cdoyle]

Yes we have security setup on the list, but I have certain fields in my lists that are hidden via the browser.

But when using Access the admin people can view and add content to these fields. So I want to be able to secure the frontend so just anybody can't get a copy of the front end and view the other data related to those records.

 

[boblarson]

Yes we have security setup on the list, but I have certain fields in my lists that are hidden via the browser.

But when using Access the admin people can view and add content to these fields. So I want to be able to secure the frontend so just anybody can't get a copy of the front end and view the other data related to those records.

That doesn't make sense. If just anybody gets a copy of the frontend, and you have security set up on SharePoint, they should not be able to see ANYTHING because they don't have read rights on the SharePoint site which means that if they get a copy of the frontend, they would not be able to do or see anything. That is one of the benefits of SharePoint over using an Access backend.

 

[cdoyle]

I don't think you understand what we have.

We have a list on our site, that is viewable by all, which is what we want.
But there are a couple columns in the list, that we have hidden from those who view with the browser.

These fields for each record are filled in by those who have the Access Front End (to add comments etc).

There is no way to set security on certain columns of a list (as far as I know), so if anyone gets a copy of the front end, and since the list itself is set readable. They can view the data in the other columns.

So I would like to somehow lock down the frontend some. Either make it so they can't shift control to bypass the forms and set a password to open.

 

[Big Pat]

So I would like to somehow lock down the frontend some. Either make it so they can't shift control to bypass the forms and set a password to open.

Do a search on this forum for ShiftBypassKey or something like that. There is a neat little aplication out there that sort of padlocks your database. I think I found it on this forum, but it might have been on another forum called UtterAccess.

I'm away from home at the moment but when I get back in a few days I'll see if I can remember to post a copy.