Microsoft Access 2010 Bible

Chapter 36: Client/Server Concepts 1193 A tier is a logical construct. It’s a way of segregating an application’s activities. Ve ...

Part VI: Access as an Enterprise Platform 1194 Many client/server databases are written as three-tier systems. The data-manageme ...

Chapter 36: Client/Server Concepts 1195 Note As mentioned earlier, splitting an Access database into front- and back-end pieces ...

Part VI: Access as an Enterprise Platform 1196 FIGURE 36.7 A database repository stores data in tables with field and data-type ...

Chapter 36: Client/Server Concepts 1197 Cross-Reference Table relationships are covered in Chapter 3. Access as an Internet data ...

...

1199 CHAPTER SQL Server as an Access Companion IN THIS CHAPTER Linking to SQL Server tables Understanding SQL Server database ob ...

Part VI: Access as an Enterprise Platform 1200 Note SQL Server Express is a free download from Microsoft. (www.microsoft.com/exp ...

Chapter 37: SQL Server as an Access Companion ..................................................................... 1201 Caution ...

Part VI: Access as an Enterprise Platform 1202 The easiest way to connect to a SQL Server database may be to use a command-line ...

Chapter 37: SQL Server as an Access Companion 1203 Figure 37.2 shows two connection screens for a tool called SQL Server Managem ...

Part VI: Access as an Enterprise Platform 1204 Let’s focus on the ODBC driver allowing Access to communicate with a SQL Server. ...

Chapter 37: SQL Server as an Access Companion 1205 The following steps describe how to set up a DSN that connects to an ODBC dat ...

Part VI: Access as an Enterprise Platform 1206 FIGURE 37.5 Selecting a data source type Enter a new DSN name Each item (if any) ...

Chapter 37: SQL Server as an Access Companion 1207 FIGURE 37.6 Select the SQL Server ODBC driver from the list of installed driv ...

Part VI: Access as an Enterprise Platform 1208 The description in Figure 37.8 is not essential, but you must provide the SQL Ser ...

Chapter 37: SQL Server as an Access Companion 1209 FIGURE 37.9 Selecting the SQL Server authentication mode NT login authenticat ...

Part VI: Access as an Enterprise Platform 1210 FIGURE 37.11 The final DSN configurations for a SQL Server connection Click Fini ...

Chapter 37: SQL Server as an Access Companion 1211 The confirmation dialog box includes a Test Data Source button. Clicking this ...

Part VI: Access as an Enterprise Platform 1212 If you don’t see the DSN you created earlier, use the Browse button to the right ...