Connecting to a Database Server
After you define a data source, you are ready to connect to it. You can use these methods to access server data:
Link to tables residing on the server
Link to views residing on the server
Use pass-through queries to send SQL statements directly to the server
Use VBA code to open the server tables directly
Create an Access Data Project (with this option, you do not define an ODBC data source)
Working with Linked Tables
The easiest method of accessing data on the server is to link to the external tables. These linked tables act almost exactly like native Access tables. When you link to remote tables, Access analyzes the fields and indexes contained in the tables so that it can achieve optimal performance. It is important ...
Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
