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?