InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 23:05:49 GMT20http://www.sqlservercentral.com/Forums/Topic1398834-147-1.aspxHi, Thanks for the response. I ticked traverse but it's still not picking the other file. now I'm trying to use a variable as a place holder for the file name but I'm still not getting that rightFri, 21 Dec 2012 00:57:52 GMTTrybbehttp://www.sqlservercentral.com/Forums/Topic1398834-147-1.aspxIn the For Each Loop, there's a checkbox "Traverse subfolders" (if the For Each File enumerator is selected). Is it checked?Thu, 20 Dec 2012 03:47:22 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1398834-147-1.aspxHi I have a lot of .mdb (ms access) files that I need to compact and archive and I'm strugling with the for each loop container. it does not traverse through subfolders, just keeps picking up the same file.please assistThu, 20 Dec 2012 00:48:55 GMTTrybbe