Using Databases Connected by ODBC

After you add the SQL Server database as a user, system, or file data source, you can link, import, or export tables in the SQL Server database to your Access database, depending on the permissions granted by SQL Server to your SQL Server account. If you have full permissions for the database, you can use tables attached from the client/server database in the same manner that you use attached Access, dBASE, FoxPro, or Paradox tables. You don't specify primary key indexes to be used with client/server tables because primary key indexes are opened automatically when you open the table for which indexes have been created, just as with Access tables.

◂◂ See Linking and Importing External Tables

Pubs is a demonstration ...

Get Special Edition Using Access 97, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.