Microsoft Access 2010 Bible

Chapter 38: Upsizing Access Databases to SQL Server 1233 FIGURE 38.8 The Upsizing Wizard report Tip The report snapshot is store ...

Part VI: Access as an Enterprise Platform 1234 l (^) Tables: Individual tables are converted to SQL Server tables. Data types ar ...

Chapter 38: Upsizing Access Databases to SQL Server 1235 It is important to understand that an Access .adp file doesn’t contain ...

Part VI: Access as an Enterprise Platform 1236 FIGURE 38.10 SQL Server field data types in an ADP database are considerably diff ...

Chapter 38: Upsizing Access Databases to SQL Server 1237 Data Type Used to Store Limitations/Restrictions Number Numeric data Us ...

Part VI: Access as an Enterprise Platform 1238 TABLE 38.2 Comparison of Access and SQL Server Data Types Microsoft Access Data T ...

Chapter 38: Upsizing Access Databases to SQL Server 1239 Although the Upsizing Wizard maps Access data types to SQL Server data ...

Part VI: Access as an Enterprise Platform 1240 Figure 38.11 shows the upsized SQL Server database open in Management Studio Expr ...

Chapter 38: Upsizing Access Databases to SQL Server 1241 world, to anyone with access to SharePoint or another application conne ...

...

Part VII Appendixes IN THIS PART Appendix A Access 2010 Specifications Appendix B What’s New in Access 2010 Appendix C What’s on ...

48_475348-pp07.indd 124448_475348-pp07.indd 1244 4/1/10 2:01 PM4/1/10 2:01 PM ...

1245 APPENDIX Access 2010 Specifications IN THIS APPENDIX Identifying the Access 2010 specifications and limits Looking at limit ...

Part VII: Appendixes 1246 Very few Excel users understand the need to break out “child” data (like phone numbers and addresses) ...

Appendix A: Access 2010 Specifications ................................................................................... 1247 ...

Part VII: Appendixes 1248 TABLE A.2 (continued) Attribute Maximum Number of fields in an index or primary key 10 Number of chara ...

Appendix A: Access 2010 Specifications 1249 Attribute Maximum Height of all sections plus section headers in Design view 200 inc ...

Part VII: Appendixes 1250 SQL Server 2008 Express Edition is a 32-bit application. It runs in a 32-bit process space when run on ...

Appendix A: Access 2010 Specifications 1251 SQL Server Database Engine Object Maximum Size or Number for SQL Server 2008 Express ...

49_475348-bapp01.indd 125249_475348-bapp01.indd 1252 4/1/10 2:01 PM4/1/10 2:01 PM ...