Digging down in a root directory.

[CooterBrown]

I was tasked with digging down in a 600+ gig root directory and building a table with all the subdirectories, objects within, and a few parameters like date created, date used, etc. The programming I can handle but does anyone have any suggestions on how this table should be built? Has anyone done this and have an Access or Excel with the normalized data structure that I can look at?

 

[Sheco]

Maybe your want a table with a parent-child relationship:
[tt]
Key Parent Name Type
--- ------ ----------------- ------
1 null C:\ folder
2 1 autoexec.bat file
3 1 config.sys file
4 1 Temp folder
5 1 WinNT folder
6 4 pron1.jpg file
7 4 pron2.jpg file
8 4 pron3.jpg file
9 5 System folder
10 5 System32 folder
11 5 win.ini file
12 9 Mouse.drv file
13 10 calc.exe file
[/tt]

 

[dglienna]

You could use the File System Object to get properties of the file. Check out this page:

http://msdn.microsoft.com/library/d...html/88dcdb0a-db3f-4cbc-9185-ada33004b1fa.asp

-David
2006 Microsoft Valueable Professional (MVP)

 

[BobRodes]

Also, though, you might for architectural purposes evaluate the "composite pattern." This is a perfect example of this pattern. If you look it up (google will reveal many examples) and need help understanding it, post back.

Keep in mind that a folder is a file with special attributes, one of which is the ability to contain other files.

HTH

Bob