SharePoint 2010 – Publishing an Access Database not started from a Web Database

Home > Blogs > SharePoint > SharePoint 2010 – Publishing an Access Database not started from a Web Database

SharePoint 2010 – Publishing an Access Database not started from a Web Database

Like This Blog 1 Spike Xavier
Added by May 29, 2012

We will begin by creating a database from a built in Access Database and then publish it to SharePoint 2010 Enterprise with Access Services configured. We will choose a template which works and then we will see what happens when we try to publish a database which is not compatible with SharePoint 2010 and see what we can do to fix it.

Verify Site Collection Features

Verify_Site_Collection_Features.png

We need to make sure that Access Services is activated. This is one of the Enterprise Features which are activated at the Site Collection level. So we go to Site Actions>Site Settings> Site Collection Features (under Site Collection Administration) and verify that the Enterprise Features are activated.

SharePoint Server Enterprise Site Collection features are activated.

SharePoint_Server_Enterprise_Site_Collection_features_are.png

Open Access 2010 and choose sample templates from the Available Templates Section.

Open_Access_2010_and_choose_sample_templates_from_teh_Ava.png

This will take us to the Available Templates section.

Choose Northwind.

Choose_Northwind..png

What the heck, why not Northwind rules. In any case this will create the file with a default name of Northwind.accdb and save it to a local drive. If this location is alright with you go ahead and choose create or you can use the folder icon to browse to a different location.

I choose to Enable Content

I__choose_to_Enable_Content.png

You will then be taken to the Northwind Login screen.

I'm going to go ahead and log in as Andrew Cencini by keeping the default selection and clicking on the Login button.

I_m_going_to_go_ahead_and_log_in_as_Andrew_Cencini_by_kee.png

This will take me to the default screen for Andrew. I can see many pieces of data but for the purposes of this demo I'm ready to publish to SharePoint.

This_will_take_me_to_the_default_screen_for_Andrew.png

I click on the File Tab which takes me to the Info screen.

I_Click_on_the_File_Tab_which_takes_me_to_the_Info_screen.png

Here I will choose Save & Publish.

I will choose Publish to Access Services

I_will_choose_Publish_to_Access_Services.png

I will run Compatibility Checker.

I_will_Run_Compatibility_Checker..png

This step is very important when publishing to SharePoint 2010.

I'll choose yes on the dialog box.

I_ll_choose_yes_on_the_dialog_box..png

Most likely you will not have closed the objects you're working with. Microsoft Access knows this and presents you with this nice dialog box to help. I choose yes.

Check Web Compatibility Issues

Check_Web_Compatibility_Issues.png

Once you run the compatibility checker the background of the top area becomes red if there are any issues, and you can click the Web Compatibility Issues to see the report.

Correct Any Issues

Correct_Any_Issues.png

Only 94 issues! Nice. Well I'm going to go for it and see what happens.

I Choose File>Save & Publish – Publish to Access Services and fill in the appropriate information, then click the Publish to Access Services Button.

I_Choose_FileSave___Publish_-_Publish_To_Access_Service_1.png

Obviously the Full URL, Server URL, and Site Name are not going to be the same for others as for me.

Publish Failed – In this case I will need to correct all of the issues before proceeding so I click OK.

Publish_Failed_-_In_this_case_I_will_need_to_correct_al_1.png

Decision Time: It's time to really take a look at how long it will take to correct the issues and if it will be worth it versus just creating a new web database. Luckily Microsoft has provided an amazing system by which you click on the error and it takes you to a page with a summary of the issue and the correct action to take to correct the problem. (See next Step)

Attempting to correct an issue.

Attempting_to_Correct_an_issue.png

You simply run the Web Compatibility report again and then click the link in the Issue Type ID column. When you click the link it will take you to a Microsoft Site with a Detailed description of the error and what to do to fix it.

Again, it's decision time, redesign from scratch, move it out of Access, or fix all the errors….

Enjoy!
Spike Xavier
SharePoint Instructor – Interface Technical Training
Phoenix, AZ

 

Videos You May Like

How to Use SharePoint Navigation Controls in a Publishing Site

0 223 2

For more SharePoint training videos in this series, see: Part 1 – Using Navigation Controls in a Collaboration Site in SharePoint Part 2 – » Using Navigation Controls in a Publishing Site in SharePoint « Part 3 – Configuring SharePoint Navigation in a Publishing Site – Activating the Publishing Feature Part 4 – How to Configure Navigation in SharePoint … Continue reading How to Use SharePoint Navigation Controls in a Publishing Site

How to Configure Navigation in SharePoint Publishing Sites

0 1143 3

For more SharePoint training videos in this series, see: Part 1 – Using Navigation Controls in a Collaboration Site in SharePoint Part 2 – Using Navigation Controls in a Publishing Site in SharePoint Part 3 – Configuring SharePoint Navigation in a Publishing Site – Activating the Publishing Feature Part 4 – » How to Configure Navigation in … Continue reading How to Configure Navigation in SharePoint Publishing Sites

Detailed Forensic Investigation of Malware Infections – April 21, 2015

4 606 5

How does an investigator hunt down and identify unknown malware? In this recording of our IT Security training webinar on April 21, 2015, Security expert Mike Danseglio (CISSP / CEH) performed several malware investigations on infected computers and identify symptoms, find root cause, and follow the leads to determine what’s happening. He demonstrated his preferred … Continue reading Detailed Forensic Investigation of Malware Infections – April 21, 2015

Write a Comment

See what people are saying...

  1. Avatar Shiji

    Great common sense here. Wish I’d thghout of that.

Share your thoughts...

Please fill out the comment form below to post a reply.