Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

Access Web Databases and SharePoint Lists

a14new.jpg Access 2010's changes to Access 2007 tables and database engine are relatively minor, unless you publish Access databases to SharePoint Server 2010 to enable browser-based intranet or Internet access with web databases. Web databases, which store tables as SharePoint Server 2010 lists and don't support VBA, serve as the replacement for Data Access Pages, which Access 2007 dropped. Chapter 23 is devoted to Web Databases.

The Access and SharePoint teams devoted substantial development and testing resources to improving the performance of tables linked to SharePoint lists by optimizing client-side and server-side caching. Chapter 22 explains how to link or move tables to SharePoint Foundation 2010, which is available to licensees of 64-bit Windows Server 2008 or 2008 R2 at no charge.

a14new.jpg Access 2010 also supports linking tables to Data Services, which can be conventional SOAP Web services with Web Service Definition Language (WSDL) files or SharePoint Business Connectivity Services (BCS) entities with Application Definition XML files that contain External Content Type metadata. Linking to Data Services is beyond the scope of this book.

  • + Share This
  • 🔖 Save To Your Account