Hide list on Sharepoint but allow user to write via Access linked list

[BoulderRidge]

I am deploying an Access 2007 app where I have converted the backend tables into Sharepoint lists. My users will have a copy of the Access frontend with forms to edit and query data in these lists.

How do I hide the lists on my Sharepoint site from these users who can otherwise access this Sharepoint 2007 site and who have permission to edit the data in these tables via the Access frontend forms where I control what they can and cannot see?

I’m a newbie at Sharepoint so I could be missing something obvious…



-- BoulderRidge B-)

 

[ehaze]

Do you want SharePoint to crawl the List(s)?
If not, navigate here: List > Settings > Advanced Settings
At the bottom, select No for Search.

This is going to take a little work (should be fun)...

Who should see the List(s)?
Do you have SharePoint Designer installed?

http://www.sharepointed.com/

 

[BoulderRidge]

Ok, looks like that Search setting will prevent the lists from coming up in search results--that's good.

What about just being able to open and view the contents directly from the list? The only persons who should see the contents are owner/admin types, a regular user should not see the content by accessing the Sharepoint site. But they need to be able to see and even edit the content when accessing the list via the MS Access front end (which will be on their desktop).

It just occurred to me that it may be as simple as not providing the general users with a link to the Sharepoint site at all--they have no reason to need it if the app handles this for them, right??

How would I tell if I have Sharepoint Designer (I am really a newbie here!)



-- BoulderRidge B-)

 

[ehaze]

What about just being able to open and view the contents directly from the list?
This would be the fun part. Using SharePoint Designer, you can edit the default pages SharePoint uses to display the Lists. FYI, users are going to need Contribute access to be able to read and write data to the Lists.

It just occurred to me that it may be as simple as not providing the general users with a link to the Sharepoint site at all--they have no reason to need it if the app handles this for them, right??
Yes and No. In SharePoint, if you click on your name at the top right of the screen, what options are displayed?

How would I tell if I have Sharepoint Designer (I am really a newbie here!)
It would installed on your desktop. If you don't have it, you can download it from Microsoft, it's free...

Out of curiosity, why are you back-ending an Access database with SharePoint Lists?

http://www.sharepointed.com/