Microsoft Access 2010 Bible

Chapter 35: Deploying Access Applications to SharePoint 1173 FIGURE 35.33 Resynchronize with the Access Services version after m ...

Part V: Access and Windows SharePoint Services 1174 Dealing with Compatibility Checker Problems Compatibility Checker does a goo ...

Chapter 35: Deploying Access Applications to SharePoint 1175 Primary key constraints All primary keys must be AutoNumber fields. ...

Part V: Access and Windows SharePoint Services 1176 Control issues Form and report headers and footers cannot contain bound cont ...

Chapter 35: Deploying Access Applications to SharePoint 1177 Query join issues The fields used to define joins between tables in ...

Part V: Access and Windows SharePoint Services 1178 SetValue, SetWarnings, ShowToolbar, SingleStep, TransferSharePointList, Tran ...

Chapter 35: Deploying Access Applications to SharePoint 1179 Table field issues Fields in Access Services tables can contain a m ...

...

Part VI Access as an Enterprise Platform IN THIS PART Chapter 36 Client/Server Concepts Chapter 37 SQL Server as an Access Compa ...

44_475348-pp06.indd 118244_475348-pp06.indd 1182 4/1/10 1:59 PM4/1/10 1:59 PM ...

1183 CHAPTER Client/Server Concepts IN THIS CHAPTER Distinguishing between the client and the server Understanding multi-tiered ...

Part VI: Access as an Enterprise Platform 1184 A client/server environment is typically used to service a single company, using ...

Chapter 36: Client/Server Concepts .......................................................................................... 11 ...

Part VI: Access as an Enterprise Platform 1186 If you’re a user sitting at the leftmost client computer and your application is ...

Chapter 36: Client/Server Concepts 1187 FIGURE 36.3 A contacts application entry screen (an Access form) The back office You mig ...

Part VI: Access as an Enterprise Platform 1188 database objects are stored procedures, user-defined functions, and triggers. Sto ...

Chapter 36: Client/Server Concepts 1189 Microsoft intends for Access to be used primarily as a single-user or workgroup database ...

Part VI: Access as an Enterprise Platform 1190 l (^) Partitioning and parallel processing: Physical splitting of tables into sep ...

Chapter 36: Client/Server Concepts 1191 FIGURE 36.4 A database server can be overloaded by too many users. Peripherals Lots of c ...

Part VI: Access as an Enterprise Platform 1192 FIGURE 36.5 Web and application server computers manage back-end server access. P ...