Hello, I am trying to write a program that loops every every file/sub-dir in a specified path and repair/compact every MDB it finds. I have figured out how to repair/compact the db, but how do I loop through every file in a specified path? Like I would tell the program to start at S:\DATA and it would find all of the MDB's in S:\DATA and its sub-dirs and repair/compact the db. Any help would be appreciated, thanks!

Thai