[AccessD] Search many mdbs for a linked table

[David McAfee]

Nevermind. I remember I wrote something like 5-6 years ago. I was able to
modify it.

It looks in a given folder (and traverses sub folders) and writes the path
and filename into a table (tblMDBs).

I then loop through those mdbs/accdbs and get all non sys tables and write
those to tblTables and to junction tables.

On Wed, Apr 29, 2020, 5:32 PM David McAfee <davidmcafee at gmail.com> wrote:

> Does anyone know if it is possible to search a directory of access
> mdbs/accdbs to look for one the has a certain linked table in it?  Trying
> to find one that has a linked table named “tbl ServExhibit"?
>
> Is that possible?
>