Distributed Queries in MS Access - Linked MS Access Server
(Page 3 of 4 )
Again, you can bring in external data by the same process. However this time it is a lot easier since .mdb happens to be one of the built-in types of file, and you can directly browse and find the file as shown here.
When you click on the Link button after choosing the mdb file, in this case Northwind.mdb, you will get the following Link Tables dialog where, again, you can select a single, or multi-select several tables to be linked.
For this tutorial only the Order Details table was linked.
Now with these linked servers, the main window of the DistributedQry.mdb file appears as shown in this picture. The tables linked to the SQL 2000 Servers have the prefix dbo attached to the table name.
Next: Creating the Distributed Query >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
