Finding mdb files

[Mota]

Hi;
Do anyone knows a way to find all *.mdb files in a computer?
Thank you.

 

[Ron Weiner]

From a DOS window
dir *.mdb /s
From Explorer
Click on the Search Button
In the Box labeled "Search for files or folders named:" type *.MDB
In the Combo labeled "Look in:" Select the Drive letter to search
Click the button labeled "Search Now"
From Access
You will have to write some recursive code that uses the built in Dir
Command. Use help to determine how the Dir command in VBA works and get
back to us if you need help writing the recursive code that will walk all of
the directories of your drive.

Ron W

 

[Mota]

I meant just coding in VBA.I know that manual ways!
In fact im searching for a way to use "SearchTreeForFiles" api,to get the
next entries.For,it returns just the first mdb it finds in the given
Drive.Do you know a way?
Thank you for ur help.