SharePoint Access Web Database

I learned this feature just today, so I decided to write about it. I found that Access Services on SharePoint 2010 will take care of your database in the form of a new subsite of the site collection that you have in place. You are basically importing the database tables that you want to publish to SharePoint into a new web database. This web database is your road to SharePoint, but you can’t simply convert an Access database into a web database, so you create a web database and import the tables from your Access database to make them web compatible. Here’s how I managed to do it.

Create a new web database. Inside the new web database go to the External Data tab and select the “Access” button in the ‘Import & Link’ section. Search for the Access database that you want to grab the tables from.

Select the database you want to pull from. Also it will ask you what tables you want to import, as well as advanced options…

From here you should Publish to Access from the File menu, considering everything went smoothly.

Type in the Site of your SharePoint site collection and Name the new web database (this will also act as the URL). Publish it and navigate to your new site!

Here’s your new web database site! Edit the Tables/Queries/Forms just like you would any document!

When you are finished you can Sync the changes from Access!

Advertisements

3 thoughts on “SharePoint Access Web Database

  1. Nice post. I was checking constantly this blog and I’m impressed! Very helpful information specifically the last part 🙂 I care for such information a lot. I was seeking this particular info for a long time. Thank you and good luck.

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