Advertisement
7_2009-2012 Databases/ Data Access/ DAO/ ADO #233937

Find linked tables in other Access mdbs

This is an Access mdb (in Access 2000 format) that searches a directory path for all mdbs with linked tables. There is a two-step process: 1) After selecting the search path, the code searches through all subdirectories building a collection of found mdbs. 2) The collection of found files is opened and each table in the mdb's TableDef collection (yes, this uses DAO, not ADO) is checked for the Connect property. If a value is found, it is added to the list box. In the event there is an error (the mdb cannot be opened, the version is incompatible, etc), the error is noted and the file can be checked later.

AI

Shrnutí AI: This codebase represents a historical implementation of the logic described in the metadata. Our preservation engine analyzes the structure to provide context for modern developers.

Zdrojový kód
original-source
Upload
Původní komentáře (3)
Obnoveno z Wayback Machine