Microsoft® Access® 2010 Inside Out

Defining a Primary Key for Web Databases

Every table in a relational database should have a primary key, and web databases are no exception. In Chapter 4, you learned that you have many options available to use for a primary key in client databases. In web databases, however, you must follow the structure of SharePoint lists, which only allows the SharePoint ID field as the primary key. From a certain perspective, this makes defining a primary key in web databases quite simple—Access automatically creates the primary key field, the ID field, for you whenever you create a new web table. You cannot delete this field from your web table, but you can rename the ID field to something more to your liking, such as VendorID or InvoiceID.

If you’re an experienced ...