Connect an Access Database to a SharePoint Foundation List

Access Hosting has a variety of SharePoint Foundation hosting plans available.  You can use these low-cost plans to start collaborating and using SharePoint in the cloud, but they also offer you a create SharePoint lists and link to them in Access 2010 or 2013 using ODBC connections.

Please note that SharePoint Foundation DOES NOT have Access Web Services or the publish to SharePoint feature – for those plans, please go here.  This is strictly a nice and easy way to get your data online and link to it with Access to get all of the features you’re used to with the Access client.

You can bring a SharePoint list into Access by importing or by linking. Importing a SharePoint list creates a copy of the list in an Access database. During the import operation, you can specify the lists that you want to copy, and, for each selected list, you can specify whether you want to import the entire list or only a specific view. Linking lets you connect to data in another program without importing that information, so that you can view and edit the latest data both in the original program and your Access database without creating and maintaining a copy of the data in Access.

Click here to get started with a SharePoint 2010 Foundation Hosting Plan

Click here to get started with a SharePoint 2013 Foundation Hosting Plan

Microsoft SharePoint Foundation Features

Browser based content administration: You manage your hosted SharePoint web site content using your internet browser.  With per item security for better data control and integrity, hosted SharePoint 3.0  has enhanced flexibility for storing more types of content.

Mobility: Access hosted SharePoint sites and content from mobile devices using a modern micro-browser and an access gateway. SharePoint 2013 uses the Windows Metro interface that is friendlier to touch screens and mobile devices.

Templates: Hosted SharePoint templates for WSS 3.0 provide out-of-the-box custom scenarios.  Microsoft SharePoint templates available through your SharePoint web site can be applied to common business tasks like tracking a sales campaign or managing helpdesks.

Store Documents online: Everybody can access documents which are stored centrally on the hosted SharePoint site.  SharePoint 2010 hosting integrates naturally and seamlessly with Microsoft Office applications. SharePoint 2013 hosting includes drag and drop features.

Blogs: With hosted SharePoint 2010 and 2013, staff members can use blogs to share information and document thoughts on a particular discussion.

Calendars: Everyone can share calendars and add tasks with completion dates to your hosted SharePoint web site with absolute control of access to specific calendars.

Task Management: Employees can share tasks, list of tasks with the project members, and create or assign tasks easily with Microsoft SharePoint site hosting.  The task list can be shared by everybody on the project to monitor the development of the project on an ongoing basis.

Create Documents Online: Using Microsoft SharePoint 2013 and 2010 hosting, each person can create documents, sheets and presentations online using the SharePoint hosting services.

Contact List: You can synchronize the contact list with your Outlook and mobile phone. You can share the contact information with other members of your site.

Announcements: You can make announcements for everyone accessing your Intranet.  News items such as a tradeshows or high sales months can also be announced to everyone at once through your hosted SharePoint web site.

Feeds: Users can subscribe to RSS feeds and new RSS feeds can be created.