Access and SharePoint 2010 Integration

Option 1:

Save the Access file into a SharePoint document library and share with others;

Option 2:

  • 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.

Option 3:

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.

Advertisements
This entry was posted in Access, Microsoft Office, SharePoint 2010. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s