[AccessD] Load from test AGAIN

Just a thought, have you tried a DoEvents after the LoadFromText in the
loop?  LoadFromText is going to go off and do it's own thing, if it does it
in a different thread (which I have seen some Access processes do), then
your code may be looping before it's ready to handle another one.  DoEvents
might let that process finish before it loops.

Drew

-----Original Message-----
From: Martin Reid [mailto:mwp.reid at qub.ac.uk] 
Sent: Wednesday, October 18, 2006 1:11 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Load from test AGAIN

Ok this has me beat
 
No matter what I try I cant get it to loop through a folder and import the
exported text files. Tried Martys stuff, Drews stuff and my own. Used file
system object to return only the file name without the extension and no
luck.

Any help greatly appreciated.
 
background
 
Access database objects exported as text files into C\|Forms
 
I think need to LoadFromText all the objects in said folder back into
database.
 
This cannot be as difficult as it seems. One at a time and naming the files
it works. Only when I go to look through all the objects does it fail. This
is almost my last example file I need and its melting my head.
 
 
Martin
 
 
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477