Office Web apps Overview

Some important feature included in Sharepoint 2010.

Microsoft Office Web Apps is the online companion to Office Word, Excel, PowerPoint and OneNote applications that enables users regardless of their location to access documents and edit documents. Users can view, share, and work on documents with others online across personal computers, mobile phones, and the Web. Office Web Apps is available to users through Windows Live and to business customers with Microsoft Office 2010 volume licensing and document management solutions based on Microsoft SharePoint 2010 Products.

Office Web Apps is tightly integrated with SharePoint 2010 Products. When you install Office Web Apps, the Office Web Apps Services are added to the list of SharePoint Services and the Office Web Apps Feature is added to the available SharePoint Features.

Office Web Apps services include the Word Viewing Service, PowerPoint Service, and Excel Calculation Services that are created and run within the context of SharePoint Services.

The Office Web Apps Feature and services integrate with SharePoint's robust enterprise content management capabilities to provide users the ability to access and work on your organization's documents from anywhere using a Web browser.

For More Detailed Information check the Below link .

http://technet.microsoft.com/en-us/library/ff431685(v=office.14).aspx

Cannot add an existing SharePoint 2007 list to a Office Access 2007 database

One of my users had this issue .

The user was trying to add an existing list to a access 2007 db . and was getting an error .

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

After we did some research i found a KB article for the same .

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

In this the Cause is mentioned as

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

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

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section

Please check out the Steps to reproduce the problem in the KB article (link) provided.