I want a concurrent multi-user access database with unique access rights for each
How to set up a concurrent multi-user database, utilizing MS SharePoint? Actually
it's very easy, and it leverages the power of MS SharePoint. You can create fast
and secure databases which can be accessed by multiple user from any location.
Requirements and Steps
You must have admin rights to MS SharePoint (being able to add "lists" and grant
user permissions on those lists). If you do, then you've got an amazing capability
on your hands.
Simply open MS Access, then go to "Create" tab and select "SharePoint Lists" and
"Existing SharePoint List" as shown below.
Then select "Link to data source by creating a linked table." and select the corresponding
table in the next window pane. That’s all there’s to it. Very simple. Feel free to
contact me if you get stuck or need some guidance or advice.
Uses - Unlimited
The potential is truly unlimited. You can create on MS Access any database you want
with the tables linked to SharePoint where the data will reside. Any user can then
open your MS Access database from any location (this being the front-end of the database)
and read or write the data, according to the MS SharePoint user account access rights
given to the particular tables, each table having unique access rights.
If you have particular questions please feel free to email us directly at firstname.lastname@example.org.
Creating a Database with Data Linked to SharePoint