Save the Access file into a SharePoint document library and share with others;
- Create lists and document libraries in SharePoint;
- Go to “Datasheet View”, open the task pane on the right, “Track this list in Access”; (Repeat this step until all lists/libraries are opened in the same Access file)
- Create queries, forms, reports and Navigation Forms in Access;
- Upload the Access file into a SharePoint document library and share with others; (You will get a fresh copy of the data each time you open the Access file from SharePoint)
- You can set the permission to readonly for other people, so that they can only update the data (linked to SharePoint lists) but not the design of the Access database, e.g., creating queries, forms, reports etc.
Create a “web compatible” Access database and publish to SharePoint. This will create a new “sub-sites” in SharePoint. Note that in order to display and modify the data on SharePoint browser, all Access elements (tables, queries, forms, reports) must be web compatible. Otherwise, you can still share the database, you can only view and edit the data using Access.