by Andy_in_nc (1 Submission)
Category: Databases/Data Access/DAO/ADO
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: 
(2 Votes)
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.
Inputs
NA
Assumes
This applet only looks for linked tables; it does not change the links.
Additionally, this searches for hard links only, not search through any links made in the code.
Code Returns
NA
Side Effects
None that are obvious.
API DeclarationsNA
VBcoders