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 of the
Look In text box to locate it. Then click OK.
The Link Tables dialog box (shown in Figure 37.14) appears, enabling you to select SQL
Server tables to link to your Access database.
Note
If this dialog box doesn’t appear, or if you encounter an error while waiting for this dialog box, there may be a
problem with the DSN.
FIGURE 37.14
Selecting tables from a SQL Server databaseIgnore all the system tables (prefixed with sys or INFORMATION_SCHEMA) in the Link
Tables dialog box. The tables you’re interested in are generally at the top of the list in the
Link Tables dialog box.
In Figure 37.14, the Customers table has been selected. This table was actually upsized
from the Collectible Mini Cars database earlier.
- Click OK to close the Link Tables dialog box and link to the selected table(s).
Note
dbo is shorthand for database owner and is the default prefix for all objects within a SQL Server database. A
full explanation of SQL Server authentication, security, and ownership is well beyond the scope of this chapter.
For the meantime, it’s enough to understand that SQL Server supports multiple users, each of whom is identi-
fied by a name. When a user creates a SQL Server object, he creates the object with either his own name pre-
fix, or with the default dbo prefix, depending on how SQL Server security is configured.