Linked Table Properties 1

[jedel]

Hi all,
I'm working on a project that links to a number of different databases as required by the operator.

Basically, I have two types of dbs, the editing db and the client db that only looks at the data (this for when its burnt onto a CD and given to the client.

As I gather more clients, The number of client dbs that I need to link to grow and sometimes I can't remember which database I've linked to.

The QUESTION:

Is there a way of determining where the linked tables come from, ie a file path, or some such thing?

Any help would be great

Cheers

Jedel

 

[JeremyNYC]

Select Name, Database from mSysObjects WHERE Database IS NOT NULL ORDER BY Database


==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.