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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access