Linking to a table from another database

lmcc007

Registered User.
Local time
Today, 03:05
Joined
Nov 10, 2007
Messages
635
I have a table with a list of company names and addresses. I am using this table in about four different Access databases. There are some changes to the list that needs to be made. Because I imported the list into each database, I now have to go and change it four times instead of once.

How shall I handle this situation? What is the best way to handle this?

Thanks!
 
instead of importing, link the table in yr 4 databases, so any changes to the backend table will be automatically reflected on yr linked tables.

try this from the database file menu:
file, get external data, linked tables
 
That did it. Thanks!
 

Users who are viewing this thread

Back
Top Bottom