Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Now let's publish a database to the Web using Access's Web services featuring SharePoint. It's a good idea to start with either a blank Web database, or with one of the sample templates that says Web Database across the bottom. While you can convert your already existing database to SharePoint, it will have some considerations. Your ID fields must be autonumbers. There are no cascading updates and deletes, and you can't use any custom formatting. We're going to go ahead and create a Contact Web Database for our example.
So we have Contacts Web Database, and go ahead and click Create. It will prepare the template, and it will look like this. We will have tabs across the top here for our different tables. Let's go ahead and add a Contact to our Address Book. So I will click on Add New, and I will enter myself in, and I'll click Save and Close. So now here is my first record in my database. Let's go ahead and publish it. I am going to go up to the Backstage View by clicking on the Red File tab, and then down here to Save & Publish, and click on Publish to Access Services.
Here's the compatibility checker that you do want to run before publishing. It's going to ask me to close my objects, and I'll say Yes, and it says this database is compatible with the Web. If you are converting your own database, it will probably turn red and give you a list of issues that you will need to resolve. Once it is compatible and ready to go, down here, type in your SharePoint URL, and my database will be called Contact Web Database. I will go ahead and click Publish to Access Services.
It'll take a minute to create all of my objects, and set up the Web site. Once it comes up, it may not be available immediately. You may have to wait a moment for it to finish resolving. So here's the link for the Web site. I will go ahead and click on it. It wasn't quite ready yet, so I will go ahead, and I will refresh it, and there it is. So here is my Address Book and here is my first record, Alicia Katz Pollock.
Now what makes this so practical is any changes that I make here, I'll click on Edit Details, and let me add in our lynda.com Web site, and I'll click Save and Close, and I will go back to Access down here. Here is the dialog box that was open. I'll close it. I'll enable the content, and here I am back in my contact, and low-and-behold it already says lynda.com down there.
The changes were instantaneous. So you can see how practical it is to use SharePoint as a way of sharing your database over the Internet. Just keep aware that not all standard database techniques are going to work over the interface.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 74465 Viewers
80 Video lessons · 129695 Viewers
52 Video lessons · 63939 Viewers
59 Video lessons · 49720 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.