How to Add an Access 2007 Database to SharePoint 2007

You can add Access 2007 database files to a SharePoint site.

Microsoft SharePoint 2007 is a collaboration tool designed for large-scale companies that need to manage large amounts of data and content. As a SharePoint administrator or user, you have the ability to add documents and other files to your company's SharePoint site. For example, you can use Microsoft Access 2007 to publish a database file onto a SharePoint site.

Things You'll Need

• PC running Windows XP or later
• Microsoft Access 2007

Instructions

1. Launch the Microsoft Access 2007 program on your PC computer and open the database file that you want to add to your SharePoint site.

2. Click on the circular "Office" button in the upper-left corner of the Access 2007 window.

3. Go to the "Publish" sub-menu and choose the "Document Management Server" option.

4. Enter the URL of your organization's SharePoint 2007 site in the pop-up window that appears.

5. Go to the location within the SharePoint 2007 site where you want to store the Access 2007 database. In many cases, database files are stored in the "Document Library" directory.

6. Enter the name that you want to use to identify the Access 2007 database in the "File Name" field.

7. Click "Publish" to add the Access 2007 file to your SharePoint 2007 site.

References

• Office Support: Publish a database to a SharePoint site