I have many MS-Access databases out on our network and am looking for a way to catalog all the data sources being used within the databases. I have the code written to run through the network locations and identify these databases. I am connecting to these using the Access Automation Object [Access.Application] with the VB.Net code. I have not been able to find the methods and/or properties to be able to interrogate these databases and expose the connection information for the data sources. I am looking for a code snippet to be able to accomplish this. If necessary I could change to an OLE or ODBC connection to the databases.
Any help would be much appreciated. Thanks................
Any help would be much appreciated. Thanks................
