Problem:

Access Denied for all SharePoint Search Pages suddenly.
You’re able to access with your service account but normal users just cant access it. You check all users with ‘READ’ permission.

Solution:

1. Access the Search top level site with Service Account, for instance.
2. Site Actions -> View All Site Content -> Document Libraries -> Pages (http://localhost/sites/search/Pages/Forms/AllItems.aspx)
3. Click on one of the page that users were not able to access. A context menu will appear and then click “Publish”
4. Users able to access the page without permission problem.

Seriously I had hard time to deal with this production issue.

Google around, found a lot of solutions such as, enable “SharePoint Server Enterprise Site Collection features”, Access Central Administration to make sure “Access Service is installed, and bind to the website”.

Unfortunately those wasn’t not able to solve the problem.

We came out a solution which is “save the Microsoft Access Web Database as template, and Create the site with the template”

To Save the Microsoft Access as “Local Database”

1. Access the Microsoft Access Web Database
2. Click” Options” -> “Open in Access”
3. Microsoft Access Launched -> Click “File” -> “Save & Publish” -> “Save Database As” -> “Save as Local Database”

To Save the “Local Database” as Template

1. Open the file you just saved
2. Click “File” -> “Save & Publish” -> “Save Database As” -> “Template (*.accdt)”
3. A window pop up -> Name it “testDB” (will be great without space between the filename), check “Application Part” & “Include Data in Template”
4. Click OK

Upload Template & Activate the solution

1. Launch IE, log on to “http://ServerName/sites/test/_catalogs/solutions/Forms/AllItems.aspx
2. Upload and Activate the solution

Create the Sub Site with uploaded template

1. Launch IE, log on to “http://ServerName/sites/test/
2. More Options -> Filter By -> Site -> “testDB”
3. Enter Site Name and URL and Save

Lastly, deactivate and delete the solution you just created.

Incoming search terms:

• failed to publish access db file to sharepoint (2)
• March 21 2012 AND sharepoint AND leave a reply (1)
• publish web database in sharepoint 2010 (1)
• sharepoint 2010 web database failed (1)
• sharepoint2010 database (1)

Access Denied when accessing properties in SPWeb with SPSecurity.Elevated Privileges as a visitor?
You may need to scan your code if you use “SPContext.Current.Site” or “SPContext.Current.Web” in your program.

To avoid access denied when you use RunWithElevatedPrivileges block, you need to create new instance of SPSite and SPWeb inside SPSecurity.RunWithElevatedPrivileges

SPSite siteColl = SPContext.Current.Site;
SPWeb site = SPContext.Current.Web;
SPSecurity.RunWithElevatedPrivileges(delegate() {
  using (SPSite ElevatedsiteColl = new SPSite(siteColl.ID)) {
    using (SPWeb ElevatedSite = ElevatedsiteColl.OpenWeb(site.ID)) {
      string SiteCollectionOwner = ElevatedsiteColl.Owner.Name;
      string Visits = ElevatedsiteColl.Usage.Visits.ToString();
      string RootAuditEntries =
          ElevatedSite.RootFolder.Audit.GetEntries().Count.ToString();
    }
  }
});

Incoming search terms:

• runwithelevatedprivileges sharepoint usage (1)
• spsecurity runwithelevatedprivileges avoid (1)
• spcontext runwithelevatedprivileges (1)
• sharepoint provision access denied spsecurity (1)
• sharepoint avoid ad usage (1)
• sharepoint 2010 runwithelevatedprivileges get spweb (1)
• sharepoint 2010 central admin spcontext (1)
• SharePoint 2010 access denied to SPWebCollection inside SPSecurity RunWithElevatedPrivileges (1)
• runwithelevatedprivileges spweb (1)
• runwithelevatedprivileges spcontext (1)

To save site as template

1. Site Actions
2. Site Settings
3. Site Actions -> Save Site as Template
4. It will save it at “http://yoursite/_catalogs/solutions/Forms/AllItems.aspx”

To create a site based on a template (create a subsite)

1. Download the template from “http://yoursite/_catalogs/solutions/Forms/AllItems.aspx”
2. Upload the site template to another site, “http://yoursite/subsite1/_catalogs/solutions/Forms/AllItems.aspx”
3. Browse “http://yoursite/subsite1/
4. Site Actions
5. More Options
6. Filter By Site, then select the template you just uploaded.

Incoming search terms:

• restore site template in sharepoint 2010 (4)
• sharepoint 2012 templates (3)
• sharepoint 2012 template (2)
• download site templates sharepoint 2010 (1)
• sharepoint 2010 save site as template download the template (1)
• sharepoint 2010 site template delete (1)
• sharepoint 2010 template download (1)
• sharepoint 2012 site templates (1)
• sharepoint 2012 upload site template (1)
• sharepoint2010 template download (1)

Problem: want to re-associate the SharePoint Designer Workflow to another document library.

Solution: using SharePoint Designer to edit “workflowfilename”.xoml.wfconfig.xml .

<association ListID="..." TaskListID="..." ...></association>

How to find out the ListID?

• Go to the List/Document Library
• List Setting/Document Library Setting
• You will to get the List ID from the Internet Browser URL
• URL looks like “http://URL/listedit.aspx?List=%7B532E2F14%2DF3B5%2D4BE9%2DA14A%2DE0DBD10E0935%7D”
• Go to “http://meyerweb.com/eric/tools/dencoder/”
• Paste the %7B532E2F14%2DF3B5%2D4BE9%2DA14A%2DE0DBD10E0935%7D
• the website will decode to “{532E2F14-F3B5-4BE9-A14A-E0DBD10E0935}”

Use that DECODED List ID to update the workflow XML file.

NOTE: if you having problem when you try to publish the workflow using SharePoint Designer,
you may delete the webcache at “C:\Users\loginnames\AppData\Local\Microsoft\WebsiteCache”

Incoming search terms:

• how to access email from in document library spd workflows 2010 (1)
• sharepoint 2010 xoml wfconfig xml cannot find association tag (1)
• sharepoint designer 2010 move document to another library (1)
• sharepoint designer 2010 workflow move document (1)
• sharepoint designer workflow 2010 (1)
• sharepoint designer workflow change list Association ListID= (1)
• sharepoint designer workflow listid (1)
• sharepoint move list workflow (1)
• sp 2010 workflow edit association listid (1)
• workflow to move document from library sharepoint 2010 (1)