[AccessD] Search many mdbs for a linked table

[jack drawbridge]

David,
I  did something like this years ago. The approach was along this set up.

Create a text file of all database names in all directories from C drive
using Dir command
C:\Users\Jack>dir /b /s c:\*.mdb > c:\users\jack\documents\oldmdbs.txt

Then read that text file into a *table* in your working database.
Set up to open a second database, and record  all non-system table names.
Loop  through each database name in the *table *and record the database
name and the table name. This gives  a list of all tables in each database.

It's been years since I did this and I haven't been able to find the
database where it was done.
Not much to go on, but I know I have used the set up ~8-9 years ago.
Hope this is helpful.
Good luck,
jack
.


On Wed, Apr 29, 2020 at 8: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?
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>