[2005] Finding locations of linked tables in MS Access
We have a large number of Access databases on our network and I'm trying to build a list of the tables in each DB, and in particular, where they are linked to.
I've written a quick VB.Net app which I can point at an Access DB, which retrieves a list of tables using the OleDbSchemaGuid functionality in .Net.
I can retrieve a list of tables and linked tables, but I can't determine where the linked tables link to (if that makes sense).
Any ideas how to do this?