Searching all MDB file names from C: Drive

[Bruce]

Hi,

I know how to find all the table names in an access database using
Opendatabase etc..

What I am stuck on is the codes to search ALL mdb files in my pc...and save
the table names in them to a table.

This is for referencing purposes so that I know which database my tables
are.

Many thanks

Bruce

 

[Roger Carlson]

On my website (see sig below) is a small sample database called
"DirectoryList.mdb". This sample shows how to "role your own"
directory/file list.

It uses the Shell() function to run a DOS DIR command and pipe it to a text
file. Then imports the text file into a table. It does it first with the
Directories under a drive and then with the file under the directory.

The sample as written displays all files, but you can easily restrict it to
..MDB files. Then you would open each file in turn, and then read and store
the table names along with the path to the file.

 

[Bruce]

Great...had to do a bit of coding but got what I needed...also..I think your
website is excellent...

many thanks
rgds
Bruce

 

[Roger Carlson]

Glad it worked out for you.