Hi Bill,
Look at the Connect property in the help file. Linked tables belong to a
TableDef collection in their respective databases. TdfLinked.connect gives
you a string that contains the name of the source database. You would have
to build a procedure that opens all your databases one at a time, goes to
the TableDef collection and gets the connect property of each table. You
would parse the connect string to get the source database and build a list
of non-duplicate source databases. If you were sure all the linked tables in
a database linked to the same database, you would only need to go to one
linked table to get the source database.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com www.pcdatasheet.com
<bi**********@grainger.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...
Hi,
Have a number of Access Databases that I inherited and want to zip a
few of them. My concern is that other active Microsoft Applications
may be linking to the database or its tables. Is there a method of
searching that will allow me to identify those MS Access files that are
linked to. I am not really concerned with itemizing the which files
link to which, but just that a link exists.
Thanks in advance for any help.
Bill