Microsoft Office Tutorials and References
In Depth Information
14. Select the tables you want to link to.
You can click the Select All button to select all the tables, but if you
have a lot of tables to select and don’t want to use all the system tables,
forget about using the Shift key to select a range. Instead, click the first
table you want to select; then alternate pressing the down-arrow key
and the spacebar until you reach the last table you want to link to.
In addition to seeing the tables from SQL Server, you see the views. A
view in SQL Server is the same as a select query in Access; it just returns
data. When you link to a view in SQL Server, that view appears as a table
in Access. Opening a SQL Server view in Design view shows you only the
list of fields, not the criteria or source tables.
15. (Optional) Select the Save Password check box if you want Access to
remember the password when you connect.
If you leave this check box deselected, users of the database will have
to know the password to log in to SQL Server. Consider the security and
sensitivity of the data when you set this option. If you choose to save
the password, Access lets you know that it cannot encrypt the password
and gives you the option to change your mind.
16. Click OK.
Access begins linking to the tables in SQL Server that you selected in
You may be prompted to select a unique identifier for some of the
tables, particularly if the view is an SQL Server view. Just click the
unique identifier for each table, and you’re on your way.
When Access is done linking to the tables, they appear in the Navigation Pane,
as shown in Figure 2-9. Instead of the table icons that you’re used to seeing,
each table has an icon with an arrow, indicating that the table is linked.
views in the
If you don’t see arrows in the icons next to the table names, you probably
chose to import the tables instead of linking to them. No problem — just
delete the tables, click the ODBC Database button in the Import & Link group
on the External Data tab of the Ribbon, and start over (unless, of course, you
meant to import the tables).