"Albert D. Kallal" <PleaseNOOOsPAMmkallal@xxxxxx> wrote in message
> [Addressed to the OP] Keep in mind that a standard
> ms-access feld is limited to 255 chars, and perhaps you
> need to use a memo field to store the results???? . . .
> here is the follwing code I use to walk a direcotry using
> the dir command....I do't belive it suffers from the 255
> char limit...
Actually the maximum file name size limit appears to be heavily embedded
into the Windows OS. I'm using Windows Vista Ultimate and the OS (or at
least Windows Explorer) prevents me even from manually renaming a file such
that its total path length is greater than about 259 characters. And when I
make the name as long as the OS will permit (such as "c:\temp\a very long
file name . . . . ."and I later try to move that file into a directory that
has a longer path name (such as my desktop, for example) the system prevents
me from doing so, informing me that "The filename is too long for the
destination folder" and advising me to either shorten the filename and try
agin or alternatively choose a destination folder that has a shorter path.
And if I "cheat a little" by renaming "c:\temp" folder to "c:\t" (which
permits me to add a few extra characters to the filename) and if I then
cange it back to "c:\temp" after adding those few extra charcaters and then
use the code you posted to run through c:\temp I get a "File Not Found"
error when it attempts to access the file with the long name.
So, it looks as though this file name length limitation is more heavily
embedded into the OS than I at first thought it might be.