List of Tables

Chapter 1: Data Access Models: Part I

Table 1.1: Selected Microsoft-Supplied OLE DB Providers

Table 1.2: ConnectModeEnum Members

Table 1.3: LockTypeEnum Members

Table 1.4: Intrinsic Constants for the SeekEnum

Chapter 2: Data Access Models: Part II

Table 2.1: Intrinsic Constants for the CommandTypeEnum

Chapter 3: The ADOX Library and Tables

Table 3.1: ADOX Type Values for the Table Object

Chapter 4: Jet SQL, the ADOX Library, and Queries

Table 4.1: Correspondence of Access and ADO Wildcard Symbols

Table 4.2: Jet SQL SELECT Keyword Predicates

Chapter 8: Microsoft Office Objects

Table 8.1: Shared Office Objects

Chapter 10: Database Security

Table 10.1: Users, Permissions, and Passwords for the ManualDemo Database

Chapter 11: Using Access to Build SQL Server Solutions: Part I

Table 11.1: Object Bar Classes in the Database Window of an Access Project

Table 11.2: SQL Server and Windows Versions Supported by Access Projects

Table 11.3: SQL Server Column Data Types

Table 11.4: DATEPART Arguments for Extracting Time Units