VBA Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am not sure if in the right place, but I have a question about VBA. Is
there a recursion depth limit? I have application that scans a directory and
goes down a directory and sub-directories to record files into an Access
table. The problem is when I test this application on a small set it does
not miss folders. When the same test is performed on a large set, the
application misses directories. This is very troublesome and very difficult
to debug. Any help would be greatly appreciated.

Thanas
 
I've never had a problem with scanning directories.

Why not post your code, in case there's a problem with it?
 
Thanas said:
I am not sure if in the right place, but I have a question about VBA. Is
there a recursion depth limit? I have application that scans a directory and
goes down a directory and sub-directories to record files into an Access
table. The problem is when I test this application on a small set it does
not miss folders. When the same test is performed on a large set, the
application misses directories. This is very troublesome and very difficult
to debug.
Click to expand...


The stack space is only limited by available RAM so I doubt
that's the problem.

Note: if you are using Dir() to get the file names, that
Dir() can not be used recursively.

If none of that helps, you'll have to post a Copy/Paste of
your code before anyone can have a hope of figuring out
what's going on.
 
Thanks for the fast reply. I am checking with my supervisor about post the
function. Thanks for your patience

Thanas
 
Back
Top