I want to work on SharePoint ! but I don’t have a SharePoint connection !!!

I want to work on SharePoint ! but I don’t have a SharePoint connection !!!

Well that sounds crazy, but what if you have an unstable VPN connection and you have to work on an important document which needs to be uploaded into the SharePoint site, or a presentation that your boss want to see and your Connection is bad.

SharePoint 2010 gives you a capability to work with more evolved Office Integration which will make your offline work easier to do and more easier to sync.

Microsoft Word 2010:

We know that we can write a blog in word and publish it to SharePoint.

One of the new features in Microsoft Office is the share option that allows you to publish a document to a SharePoint site without having to manually upload it. After your done writing up your document in word > Click the File tab > select Save & Send  > Send to SharePoint > select a SharePoint location > the document will be automatically uploaded to SharePoint site.

Also located under the file tab is the info tab which displays SharePoint related information of the site like setting permissions, checking document properties, checkin- checkout information.

Microsoft Workspace 2010 (formally Known as Groove)

As mentioned in my earlier post Workspace is an offline client and it can be used to work with the contents in the SharePoint site, a few things about the working with the Workspace.

1.       You have to first sync it to the SharePoint site and wait for the site to get a copy of the download, the time depends upon the size of your website.

2.       Sync site by clicking New option on the Home Tab, Type server name and Sync

3.       The sync will begin and show all status at this moment your online with SharePoint.

4.       List of operations you can do with the “Offline SharePoint Workplace”

Ø  Work with InfoPath forms via Project tasks list.

Ø  Work with list and libraries.

5.       List of things you cannot do with the offline workspace.

Ø  Cannot work with calendars.

Ø  Cannot work workflows.

Hope this post would help you to work better with Office and SharePoint

Problem connecting exsisting SharePoint list with Microsoft Office access 2007 database

Error message:

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

Problem description:

When you try to add an existing SharePoint list to a Microsoft Office Access 2007 database then you receive an error message that resembles the following:

Resolution:

·         Checked the number of groups which are present on the site and user permissions on the site as well as for the specific list that we trying to connect

·         User has Full control on the site as well as for the list also so problem is not from SharePoint end

·         Checked the office application installed on the system and found multiple version which consist of office 2003 as well as office 2007

·         Checked the access version and found out it belongs to Office 2007 suite

·         Checked on my machine to reproduced the same and we are able to reproduced it so the problem is not from the Office suite

·         User conveyed that it’s working on one of the SharePoint site and compare both the sites and found out some differences in terms of columns and characters but to make sure did research and found the Microsoft KB

Microsoft KB states that it’s a known issue. Details as follows:

Cause:

This problem occurs because the Access 2007 database engine disallows columns that have names that contain more than 64 characters.

Workaround:

To work around this problem, use only column names that contain less than 64 characters in SharePoint lists.

Resolution for this issue:

There was one column which has more than 64 characters, we shorten the column name and tried connecting the list to access and it works without any issues.

How to reproduce the problem:

·         In a SharePoint Web site, click Lists in the View All Site Content pane.

·         Click Create, and then click Custom List in the Custom Lists column.

·         In the Name box, type Test List, and then click Create.

·         Click Settings, and then click Create Column.

·         In the Column name box, type NewColumnWithColumnHeaderLengthOfMoreThan64Characters1111111111111111111111, and then click OK.

·         Click New, type First Value in the Title box, type Test Value in the NewColumnWithColumnHeaderLengthOfMoreThan64Characters1111111111111111111111 box, and then click OK.

·         Start Access 2007.

·         Click Blank Database in the New Blank Database section, and then click Create.

·         Click the Create tab, click SharePoint Lists, and then click Existing SharePoint List.

·         In the Site Address list, select the Windows SharePoint Services Web site in which you created the Test List, and then click Next.

·         Click to select the check box for the Test List, and then click OK.

Microsoft Office

Step into the Microsoft Office Virtual Labs for Free

It's simple: no complex setup or installation is required to try out BizTalk Server running in the full-featured TechNet Virtual Lab. You get a downloadable manual and a 90-minute block of time for each module. You can sign up for additional 90-minute blocks any time.

Microsoft Office 2010

• TechNet Virtual Lab: Office Compatibility: Office Files in a Mixed Environment
• TechNet Virtual Lab: Office Compatibility: Office Compatibility Tools to Ready Deployment
• TechNet Virtual Lab: Office Compatibility: Office Document Conversion
• TechNet Virtual Lab: Office Compatibility: Macro Evaluation
• TechNet Virtual Lab: Using Business Connectivity Services with Microsoft Office 2010
• TechNet Virtual Lab: Analyzing and Reporting with the Excel 2010 Client
• TechNet Virtual Lab: Microsoft Project 2010 and Microsoft Project Server 2010 Overview
• TechNet Virtual Lab: MDOP: Sequencing Office 2010

Getting Started

• System Requirements
  
  Before you get started, read the minimum system requirements.