Access 2007 Programming by Example with VBA, XML, and ASP

Chapter 12Setting Up Primary Keys, Indexes, and Table Relationships

After defining the fields for your tables, take the time to define primary keys, indexes, and relationships between tables. This chapter focuses on the DAO and ADOX objects that are designed to work with these features.

Creating a Primary Key Index

Indexes determine the order of records accessed from database tables and whether or not duplicate records are accepted. While indexes can speed up access to specific records in large tables, too many indexes can also slow down updates to the database. Each table in your database should include a field (or set of fields) that uniquely identifies each individual record in a table. Such a field or set of fields is called a primary key ...