Microsoft Access 2010 Bible

Part VI: Access as an Enterprise Platform

1214

FIGURE 37.16

A table linked from Access to SQL Server is named dbo_TableName by default.

Local tables

Linked SQL Server tables

The ability to link to many different data sources is a fundamental advantage of using Microsoft

Access over other desktop database systems. Access and SQL Server integrate particularly well, and

users are seldom aware that they’re using data hosted in a remote database in a properly main-

tained Access application.

Working with SQL Server Objects

SQL Server contains many types of objects that are not supported in Access.

SQL Server supports database objects such as stored procedures, functions, and triggers. So far in

this chapter, I’ve only covered using Access tables linked to SQL Server tables, but most SQL

Server databases include more than just tables.