Modify a Linked Table

[Guest]

I am a new user. How do I modify a column name of a linked table?
Also, how do I find out what are linked to this table?

 

[Rick Brandt]

I am a new user. How do I modify a column name of a linked table?
Also, how do I find out what are linked to this table?

You have to open the file where the REAL table is, not the one with a link
to it.

From the file containing a link you can look at the Connect property to see
what file the table being linked to resides.

You cannot use the file containing the real table to determine what files
have links to it. The entirety of the linking mechanism resides in the file
containing the link. The file being linked to has no knowledge of the files
that are linking to it.

 

[Bill Mosca, MS Access MVP]

The Connect property Rick mentioned can be seen in the hidden system table
named SysObjects. Click on Tools>Options>View tab and select View System
Objects.

 

[Guest]

Or, alternatively, run the following query to reveal the paths:

SELECT Left(Database,255) AS [Linked Databases],
Count(MsysObjects.Database) AS [Number of Tables]
FROM MsysObjects
WHERE (MsysObjects.Type)<>9
GROUP BY Left(Database,255)
HAVING Left(Database,255) Is Not Null;

Notes:
1. Grouping on the first 255 characters is required for Access 97, but not
later versions, since [Database] is a memo data type. (Contributed by Doug
Steele).
2. The criteria, WHERE (MsysObjects.Type)<>9, is used to filter out any
table constraints created with ADO. (Contributed by Dirk Goldgar).


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Thanks.
But how do I look at the connect property?

 

[Rick Brandt]

Thanks.
But how do I look at the connect property?

Open the link in design view and then View - Properties. The same data is
found in the Description property of the Properties sheet.

 

[susiedba]

if you just used an Access Data Project your life might be a LOT
simpler

none of this junk to deal with; a single simple connection and you're
off to the races.
better adminstration; better security.. better ETL; real scheduling
capabilities.

MDB shouldn't be used by anyone for any reason whatsoever

-Susie, DBA