GetFolder().SubFolders limitations

[Geates]

For the past 2 years, our logon script has been auditing user logons in the form of text files stored at \\server\computer_name\user_name\date_time.txt - there are more than 1.25 million audits in 50,000 folders. I modified the way we audit logons to a DB solution. I'd like the import these files into the DB but it seems as though .SubFolders can only collect so much of the directory structure as the import "finished" before it had even reached the half-way point.

Is there a way to filter against what .SubFolders collects BEFORE it collects?

-Geates

"Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live."
- Martin Golding

 

[jges]

If your problem is still unsolved, I suggest posting some relevant code. Otherwise we would just be guessing.

 

[mrmovie]

presuming you are saying
\\server\ share has 50,000 subfolders, but
Set objFolder = FSO.GetFolder(\\server\share).SubFolders.Count is not giving you 50,000?
I presume you have 50,000 computers? i doubt you have had 50,000 users log on to one specific computer...

I Hear, I Forget
I See, I Remember
I Do, I Understand

Ronald McDonald