Build A Table Of Search Results

[DALIEN51]

Using Access 2000 is it possible to specify a starting location ie (c:\) and using VBA search every sub folder from this point for files ending .mdb or .xls?

I want to be able to build a table with an record showing the file name and directory for each file found.

Any help most appreciated.

Regards,

Dalien51

 

[Ron_dK]

I haven't tryed this one myself yet, but I think it is a good pointer :

http://www.access-programmers.co.uk/forums/showthread.php?t=71532&highlight=search+mdb+files

 

[ghudson]

HOW TO: Recursively Search Directories by Using FileSystemObject

Searching the forum is a great way to discover and learn the answers to your Access programming questions.