O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Linked Tables in Access 2002

In Access 2002, the creation and linking of linked servers and ad-hoc links have all been simplified. Access 2002 provides the Link Table Wizard for creating table links (see Figure 24-7). This wizard can be started by selecting File, then Get External Data, and then Link Tables. The wizard does, however, have a significant restriction: Table links can only be created with the wizard if the Access project is linked to a local SQL Server and/or MSDE (that is, the database must run on the same computer as the project). This restriction is easy to explain because, as described earlier, OLE DB or ODBC information is used for linked servers or ad-hoc links. This information must be present on the computer running SQL ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required