>>when doing a recursive dir listing using the scripting.filesystemobject method. In the insert command I am using the following:
>>
>>INSERT INTO filesFSO (Path, Filename, Size, Created, Modified);
>>VALUES (.Path, .Name, .Size, .DateCreated, .DateLastModified)
>>
>>at which point i get a OLE error code 0x800a0005: Unknown COM status code msg box.
>>
>>BUT, when I leave the .DateCreated out, it runs just fine. Takes forever but it runs :)
>>
>>Any ideas what is causing this error to creep up with the .DateCreated?
>>
>>TIA!
>
>Robert,
>I never got the error. Identify the file and check its properties in explorer. Also try same directory with adir().
>BTW takes forever ? It took 20 secs on mine to create 12000+ files list.
>Cetin
Yuppers.. to do a listing of just 18000 files took over 20 mins. and there's about 61000 total files and directories on the drive I'll be running it on when the prg is fixed. I wouldn't even have this problem if the network manager didn't keep changing his mind on what he wanted the program to show.. geez.. I'm getting ready to just knock him up side the head and to tell him to just go away. :) Maybe I should just tell him that he will take what he gets and like it..hehe
Robert Herrmann
Texas Cancer Registry