O'Reilly logo

Integrating Microsoft by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Section 2. The Access 2007 (accdb) File Format and SharePoint

It is important to understand that if you want to integrate with SharePoint data from within Access, not only must you use Access 2007, but you must also have your database stored in the Access 2007 (accdb) file format. There are a few reasons for this. The first is multivalued lookup fields, new to Access 2007 and the accdb file format. Multivalued lookup fields enable you to store multiple values in a single field, creating in effect a many-to-many relationship within the field. An example is a SoldBy field. You can place the names of all the salespeople in a single field and use that field as a lookup for what salesperson is associated with a particular order. Because SharePoint ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required