[AccessD] Load from test AGAIN

DWUTKA at marlow.com DWUTKA at marlow.com
Wed Oct 18 13:43:40 CDT 2006


Still could be a timing issue.  About how long does it take for it to do it
when you do just one?  Put in a simple timer to 'pause' the loop a few
seconds longer then it takes to run the process....

Drew

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

No luck
 
Martin
 
its odd becasue if you run a simple application.loadfromtext it will bring
the file in even with the txt extension. 
 
So I cant see why if you use a loop to grab them all it would  fail. 
 
Martin
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477
 

________________________________

From: accessd-bounces at databaseadvisors.com on behalf of DWUTKA at marlow.com
Sent: Wed 18/10/2006 19:21
To: accessd at databaseadvisors.com
Subject: Re: [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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/> 





More information about the AccessD mailing list