MS Access 2003 Step By Step - Asim Abbasi
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Chapter 2: MS Access Local & Linked Tables
Creating Linked Tables
On the other hand tables having structure as well as the data residing
in other databases like Oracle outside of your MS Access database are
called External/Linked Tables. Whenever you would like to have a table
(any table outside of your MS Access database e.g. one residing in
another MS Access database or MS SQL Server or Oracle etc.) linked to MS
Access then click on the “Tables” object under the “Objects” group. Next
click “New” which will open up the New Table window with multiple table
related options. The option of our interest would be “Link Tables”.
1. Whenever you have to do any thing with
tables. Click the Tables object.
2. As you are creating a new linked table, click the New command
as depicted in the screenshot with label 2.
3. From the popped up window select the option Link Table.
4. Finally click the <OK> button.
After clicking the <OK> button, another window will pop up which you will use to locate the database and the table to be linked. If the table resides in database like Oracle, MS SQL Server, MySQL etc. then first you need to setup the ODBC connection whereas if the table to be linked resides in the other MS Access database then all you have to do is to select that database and finally the table. No ODBC connection is needed in this case.
Chapter 2: MS Access Local & Linked Tables
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Share with others: