How to Publish an Access Database to SharePoint

When you publish a database to a SharePoint site, you can share the data with other people who use the SharePoint site while you continue to use Access as the front end for the forms, reports, and queries in the database.

There are two ways that you can work with a published database. If you are a database designer, you can build queries, forms, and reports that use the data from the SharePoint site. If you are a database user, you can use Access to enter, view, and analyze data from the SharePoint site.

You can publish a database that you already created, or you can build a database from one or more tables that are linked to SharePoint lists or libraries. When data from a SharePoint list or library is linked to an Access table, you can create views for those lists or libraries that are based on forms, queries, and reports in Access. This enables you to build an Access application that tracks the data on your SharePoint site.

Publishing a database to a SharePoint site is available only for database files that are saved in the Office Access 2007 format.

extradrmtech

Since 20 years I work on Database Architecture and data migration protocols. I am also a consultant in Web content management solutions. I am an experienced web-developer with over 10 years developing PHP/MySQL, C#, VB.Net applications ranging from simple web sites to extensive web-based business applications. When not writing code, I like to dance salsa and swing and have fun with my little family.

You may also like...