Access 2010 & Sharepoint

[Altin]

I have created a list of archived documents in SharePoint from a ~1900 row spreadsheet. I want to make this list searchable by all users at our site & manageable by a select few. In its current state, the easiest way for a user to search this is to export the list to a spreadsheet & use Ctrl + F to find rows with the specific text they are searching for. Its not very user friendly for searching or for the group who will have to manage & update specific entries. A MySQL database & PHP webserver would be a better solution but we don’t run one at our site.

I had heard that Access 2010 is able to interface with SharePoint & & I was wondering if this would be a feasible option. I have a good bit of experience with Access 2003, and I have heard that Access 2010 is able to produce webpages. Would it be possible to interface Access 2010 with the list in SharePoint & use this to return search queries to a webpage, or for management of the Sharepoint list? Where would I begin inlearning how to do this?


Thanks

 

[Pat Hartman]

You can create an Access FE that links to the Sharepoint table and have the users use Access to search and report on the list.