You do not have the necessary permissions to use the '' object" + SharePoint2007 + Access

Issue: Connecting a List to Access database throws an error message.

You do not have the necessary permissions to use the '' object. Have your system administrator or the person who created this object establishes the appropriate permissions for you.

Background: One of my clients trying to connect a SharePoint List by MS Access. After waiting some time, getting error message specified above. Also getting the same error message when trying to connect to MS Access from SharePoint by converting the list to data sheet view

System Information:

1)   Windows XP

2)   Office 2007

3)   Access 2007

4)   Access 2010

5)   SharePoint 2007

Troubleshooting:

1)   Tried to save list as a template and created a new list issue persist in both cases when saved with content and without content.

2)   Tried to connect same list to excel and did not work.

3)   Tried repairing the office suit, didn’t work at all.

4)   This seems to be clearly an issue with the SharePoint List.

Resolution:

Tried looking at columns side of the list and did some deep dive based of the exact error were getting and found the below KB from MS, which was the resolution of the problem and gave a clear instructions to reproduce the issue.

http://support.microsoft.com/kb/924739

Checked the columns names on the List and there were two columns which were using more than 64 characters in it title field.

Eliminating them from the list and connecting List again from MS Access to SharePoint does work and vice versa.

Applies to:

1)   Windows SharePoint Service 3.0

2)   MOSS 2007, MS Access 2007

3)   MS Access 2010.

If you have any queries/questions regarding the above mentioned information then please let me know.I would be more than happy to help you as well as resolves your issues, thank you.

Pages are opening abruptly in IE7 when sending page as Email: SharePoint 2010

Issue: When a client send a SharePoint Site Page via IE it was opening abruptly in Email.

Background: One of my clients was trying to send the SharePoint as a page using the IE options, File – Send – Page by Email the page was opening abruptly. Nothing was in place. As unexpectedly it should be send by as a normal webpage.

Troubleshooting:

Checked the IE settings.

Cleared the cache of IE,

Restored the IE factory settings but no luck in any case.

It seems to be more of the page layout issue.

Trying out IE options doesn’t help me. I gave a try to the play with outlook settings.

Checked various settings with outlook.

Changing the mail format settings to rich text did helped to resolve the issue.

Resolution:

Change the mail format to Rich Text and then send the Page as Email from IE.

For outlook 2007

1.    .Open the outlook

2.    On the Tools menu, click Options, and then click the Mail Format tab.

3.    In the Compose in this message format list, click the format that you want.

4.    Open IE, from File tab open the Send, Click Page by Email.

http://office.microsoft.com/en-gb/outlook-help/change-the-message-format-to-html-rich-text-or-plain-text-HP001232996.aspx

For outlook 2010

Open the outlook.

1. Click the File tab.
2. Click Options.
3. Click Mail.
4. Under Compose messages, in the Compose messages in this format list, click HTML, Rich Text, or Plain Text.

http://office.microsoft.com/en-gb/outlook-help/change-the-message-format-to-html-rich-text-or-plain-text-HA101992313.aspx

5.    Open IE, from File tab open the Send, Click Page by Email.

Following the above steps should send the page in the normal way as you see it in the browser.

If you have any queries/questions regarding the above mentioned information then please let me know.

I would be more than happy to help you as well as resolves your issues, thank you.

Applies to: SharePoint Foundation Server 2010, SharePoint 2010. IE7, IE8, Outlook 2007, Outlook 2010. 

Template for information Gathering or SMTD: SharePoint 2010

I have been working on an assignment and currently running in KAP phase of my assignment. You all know KAP phase is very important and need to run thoroughly with better care because it builds base of operation support.

I always regard “KAP without proper attention is a big GAP”.

As discussed in my last articles Phases of SharePoint Transition Plan: SharePoint 2010 (Knowledge Acquisition Plan) and What does it take to become Transition Manager: SharePoint 2010?, I discussed about the phases of KAP and touched little on SMTD i.e.  System Maintenance Technical Document, I realized that while understanding the clients different environment and having multiple sessions with the SharePoint SMEs, we tend to miss some of the important points to note down regards SharePoint environments.

Below I have collated some points for the reference to capture the most information related to SharePoint environments. It is always important to gather below information.

Ø Version of O.S

Ø Versions of SharePoint Server

Ø Versions of SQL Server O.S and SQL

Ø SharePoint Server Setup Architecture (With Diagram)

o   No Of App Server:

o   No of Web Servers:

o   No of Index and Query Servers:

o   CA is hosted on:

o   SQL Servers:

Ø Which Servers holding index and query server roles

Ø No, Dev, Staging, Pre-Production and Production environments.

Ø Load Balancer info.

Ø Excel Cal. Service, InfoPath Services etc.

Ø Outgoing and Incoming Email services

Ø Special Service Accounts information and rights

Ø Back-up and Restore Policy (If any third Party S/W is used)

Ø Site Creation, Administration Change, Site Deletion Process

Ø DR Process and Policies

Ø SQL Server set-up for the DR Process (DB Mirroring)

o   DB Structure

o   Content DBs

o   Search Config

o   Search Content

Ø Any Scheduled jobs running of the SharePoint Servers and Warm scripts

Ø Health Check Process and Monitoring of the services

Ø How the change and Problem management process

Ø Any current issues for SharePoint or on O.S Side.

Ø SharePoint and O.S Patching Process

Ø Service Applications List.

Ø Web Application List

Ø Maintenance Window

Ø BI features i.e. BDC and BCS.

Ø SQL Reporting and other reporting tool used.

Ø Any other reporting done.

Ø Any other additional Information

To gather information on Search:

Ø Search usage – for Content search or itemized search features (like directory)

Ø How many users perform the queries per day?

Ø List of search pages.

Ø Does users use Advance search and if any customizations.

Ø How many content sources and their names. How many totals are in use?

o   Content Sources:

1.     How many items we have per content source.

2.     Schedule of the incremental and full crawls of the content sources.

Ø Search Infrastructure:

o   No. of Query Server:

o   No. of Index server:

o   Index size in GB:

o   No. of total items indexed:

o   Search Database size:

Ø Reports:

o   Daily search hits:

o   If OOB 30 days reports:

o   Most used Keywords:

Ø Best Bets:

o   No of best bets already in place, including the best bets from all the content sources.

Ø Additional Notes:

o   If any

Ø Current Issue:

o   If any

I hope this piece of information is helpful and useful.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Applies to:

·        SharePoint 2010,

·        SharePoint 2013. 

The specified file is not a valid spreadsheet or contains no data to import - SharePoint 2010

Desktop attributes:

OS: Windows 7 64-bit

SP version: SharePoint server 2010

IE version: IE 8.0, 64-bit

Office version: Office 2010, 32-bit.

Amazing string of problems let me explain one by one!

Problem description#1:-

I need to import the spreadsheet on my SharePoint site so I opened my SP site - site actions – more options – clicked on ‘Import spreadsheet’ option. As soon as I clicked on it, it throws the following exception.

Error message: -

This feature requires Microsoft internet explorer version 5.0 or later, and windows 95 or later.

The above error message is somewhat misleading with respect to the above mentioned desktop attributes. If I am already using IE8 then how this error message is showing ‘use IE 5 or later’ also OS is also windows 7 which is far more advanced than windows 95—strange huh…

But then I realized that as per MS recommendations, most of the features are not compatible with 64-bit IE so the IE version is the main culprit.

In this situation, obviously anybody will think / take the decision of IE uninstallation but let me tell you guys- you don’t have to take such drastic step.

What you have to do-

1)   Start

2)   All programs

3)   In that list, you will see two internet explorers, one will show you 64-bit and other one without any version

4)   The one which is showing without any version, that will be your 32-bit IE

5)   You have to open your SharePoint site in that version i.e. 32-bit IE

6)   Please refer the following screenshot for more details.

7)   As soon as you will open your SP site in this version, then the issue will be resolved.

Ok, so far so good! - Lets switch to next problem now-

I clicked on Import spreadsheet, given the list name and selected the file that I wanted to import and clicked on import.

As soon as I hit import then got the following error message:

The specified file is not a valid spreadsheet or contains no data to import

Resolution:-

1)   Close all the internet explorers

2)   Open a new IE

3)   Tools

4)   Internet options

5)   Security

6)   From the several zones, select Trusted sites

7)   Sites button will be highlighted- click on it- add your SP site URL

8)   Click on close button and then Click OK

Note:-

1)   Make sure the protected mode should be disabled and

2)   Reduce the security (range is between- High, Medium and Low), it should not be high.

That’s it; try to import the spreadsheet now and it will work like a charm.

Happy SharePoint to all of you

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

connect to office disabled in sharepoint 2010

Connect to office is a very vital feature if you are working with lots of libraries and lists. One of our users reported an issue that he is not able to use the ‘connect to office’ drop down menu.

Desktop entities:-

Windows 7 OS

IE 9 32-bit

Office 2010 32-bit

SharePoint Server 2010

Problem description was not clear so further probing, we came to know this option is disable/greyed out. Strange! No ideas as I have never used this functionality before the issue actually reported to my team.

I started my research by learning the default functionality:

http://office.microsoft.com/en-in/sharepoint-foundation-help/connect-to-office-HA102080653.aspx

Issue description:-

Connect to office disabled / Connect to office disabled is greyed out.

Error message:-

Connect to office, this control is disabled.

Note:-

Before you start troubleshooting on this issue, make sure that you have enough set of permission to perform this activity.

Troubleshooting done:-

1)   Cross-checked the office version is 32-bit or not. It should be 32 bit only and not a 64-bit.

2)   Cross-checked the IE version is 32-bit or not. It should be 32 bit only and not a 64-bit.

3)   Tried opening the SharePoint site in Mozilla Firefox as well as Google chrome but same results i.e. option is disabled.

4)   Repaired the office version but that didn’t resulted any success.

5)   Tried enabled-disabling add-ons in internet explorer but no success

6)   Tried adding the SharePoint site in trusted location by means of IE but still no results.

7)   Checked on different desktops who were using IE 7, 32-bit as well as Office 2013, 32 bit but no results

Resolution:-

After the exhaustive troubleshooting for hours then I got the following article and I wanted to convey my Million Thanks to Mr. Brian for sharing this valuable information with all of us: http://mywinsysadm.wordpress.com/2011/07/28/sharepoint-connect-to-office-for-new-document-creation

As per this article- MySites must be configured with the Use Personal Features permission turned on.  You can enable this by going into the Central Administration Console, click on Manage Service Applications, click the link for the User Profile Service Application, and select Manage User Permissions.

That’s it. I got the direction, followed as per the mentioned instructions and the issue has been comes to an end. Happy SharePoint!

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.