Microsoft Access 2010 Bible

Chapter 37: SQL Server as an Access Companion 1213 Depending on whether the SQL Server contains a primary key, you may or may no ...

Part VI: Access as an Enterprise Platform 1214 FIGURE 37.16 A table linked from Access to SQL Server is named dbo_TableName by d ...

Chapter 37: SQL Server as an Access Companion 1215 There are two approaches to sharing SQL Server data at the table level: l Imp ...

Part VI: Access as an Enterprise Platform 1216 FIGURE 37.17 Adding a new record to an Access copied table FIGURE 37.18 Making ch ...

Chapter 37: SQL Server as an Access Companion 1217 This is the script used in Figure 37.17: USE NORTHWIND INSERT INTO Employees ...

Part VI: Access as an Enterprise Platform 1218 that may join tables, sort the data, and perform other fundamental operations on ...

Chapter 37: SQL Server as an Access Companion 1219 FIGURE 37.21 A SQL Server view is equivalent to an Access datasheet. Stored p ...

Part VI: Access as an Enterprise Platform 1220 l (^) They’re stored in a semi-compiled, interpretive state on the database serve ...

Chapter 37: SQL Server as an Access Companion 1221 This code is intended simply to show how ADO is able to run a SQL Server stor ...

...

1223 CHAPTER Upsizing Access Databases to SQL Server IN THIS CHAPTER Considering SQL Server Express as an Access database engine ...

Part VI: Access as an Enterprise Platform 1224 On the CD-ROM This chapter uses Chapter38.accdb database on this book’s CD. If yo ...

Chapter 38: Upsizing Access Databases to SQL Server .............................................................. 1225 SQL Serv ...

Part VI: Access as an Enterprise Platform 1226 even in the past year or two might be starting to strain the organization’s netwo ...

Chapter 38: Upsizing Access Databases to SQL Server 1227 Running the Upsizing Wizard After you’ve completed the steps to prepare ...

Part VI: Access as an Enterprise Platform 1228 The second dialog box of the Upsizing Wizard asks for the location of the SQL Se ...

Chapter 38: Upsizing Access Databases to SQL Server 1229 FIGURE 38.3 Selecting tables for the upsizing operation FIGURE 38.4 Spe ...

Part VI: Access as an Enterprise Platform 1230 FIGURE 38.5 Choosing how you want your Access application upsized You could just ...

Chapter 38: Upsizing Access Databases to SQL Server 1231 FIGURE 38.6 The final Access Upsizing Wizard dialog box If, instead of ...

Part VI: Access as an Enterprise Platform 1232 FIGURE 38.7 Waiting for the Upsizing Wizard to complete the conversion process Wh ...