Creating directory Tree, Access 2002, Windows XP

[Guest]

I am trying to set up code to automatically build a tree of empty directories
using VBA in MS Access. Being a fairly new programmer... I have spent
considerable time searching web data, but seem to be just circling close to a
solution.

Here's the set-up. I will use a simple Access database to collect folder
and sub folder names that a team will want to use a directory structure
standard for a given development project. I want to read from that list to
create the directories.

At this point, (thanks to some very generous code provided out on the web) I
have an explorer window opening up and can select the starting directory from
there. I can do a basic mkdir to that path for a single new directory, but
for some reason I am dead heading on setting up the loop structure to read
through the records and build the directories.

Any help would be greatly appreciated.

DJ

 

[Allen Browne]

Might be quicker to shell xcopy with the /e switch and a filespec that
nothing matches.