• Zip Code Radius Tool |
• About Eraserve AP |
• MS Access Tutorials |
• MS Access VBA

Back To Top

Simple MS Access Link Table tutorial for 2000, 2002, 2003

Pretty much in all versions, from Access 97 to 2007, the process is similar. There may be some visual differences between versions. This article will be using MS Access 2003.

To begin you must open a MS Access database for which you wish to link a table in. Once open click Tables in the left hand object menu and then right click in an open area. You will then see a context menu that will include "Link Tables", click it.

Go here to Re-Link Tables in VBA

Once you have selected your file type the "Link Spreadsheet Wizard" will pop up and walk you through this part of the process. Simply click next and make any adjustments as necessary. For instance after the "Link Spreadsheet Wizard" window pops up and you click "Next", when linking to an Excel file, you can choose to include the Excel files field names.

The last part of the "Link Spreadsheet Wizard" will be to name the new table. Once you have the named the table Click finish and view your new Linked table. With linked tables you can add and delete new data however you will not be able to modify the current fields. To modify the actual Linked Table's fields you will need to go to where the Linked table is linked from and modify them there.

Linking from other MS Access Databases is a little simpler. You start out the same by right clicking in the Tables area and selecting "Link Tables". You then select your "File Type" as "Microsoft Office Access (*.mdb;*.mda;*.mde)". Once you select a file a window named "Link Tables" will appear listing the tables contained. Simply select a table and then click ok.

For further help or suggestions go here: MS Access tutorials, Tables, Queries and later: Forms

You may post this tutorial on your website or in a forum. If you do please maintain a Link to Eraseve AP.

For further MS Access tutorials go here: MS Access tutorials