Changing A Linked Table Name

Access allows you to link multiple tables, but you can't change any data on a linked table. However, you can change the name of the linked table by creating an alias. Follow these steps:

Don't worry about the real table--you're not really changing the table's name, just creating an alias, and you see that alias only in the current database.

Tip comes from Susan Sales Harkins, a private consultant specializing in Access and VBA development. She currently has two technical books on the shelves: "Using Microsoft Access 97" and "Using Microsoft Access 2000." Both are QUE publications.
ag_button3   Just click on the button for the Tiproom's Home Page.
Date of last revision: 16 August 2001.