My current project is to compare the contents of two folders (FolderA and FolderB), which have multiple levels of subfolders; if there is an exact duplicate file (FolderA\SubA\Sub1\File1.ext and FolderB\SubA\Sub1\File1.ext with the same modified time), flag it in a table (or perhaps take other actions).
I used to use Application.FileSearch to get a listing of files, including the full path and filename, and put them into a recordset. It would optionally search all subfolders. How to do that in Access 2010 without FileSearch? I've researched the Dir function, but a quick trial showed it does not search subfolders - it appears you have to keep drilling down by searching for folders and building path strings. Is there any other function or procedure?
Thanks for any advice!
Windows 7, Access 2010
Peter