Import/Network Issue

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

Guest

Hi,

I have an Access 2003 that has an import procedure that checks an import
directory. The directory contains multiple excel files. The procedure loops
through the directory and imports that files. After each file is imported,
the file is moved to an archive folder. A log file is created that records
the name of each file and the number of records imported. Occasionally, the
system just hangs. Like this morning, it imported 7 of 9 files but on the
eighth file, it stopped importing. The log recorded the file name but no
records were imported from that file. I'm wondering if there was a short
network disconnect, if that would cause this. No error is thrown - the
"Please wait while processs......" form just remains displayed.

My question is 2 fold, what might be causing this and if it is a network
communication issue, how can I capture the interruption?

Hope I have explained this thoroughly enough.
Thanks
LeAnn
 
LeAnn said:
Hi,

I have an Access 2003 that has an import procedure that checks an import
directory. The directory contains multiple excel files. The procedure
loops
through the directory and imports that files. After each file is
imported,
the file is moved to an archive folder. A log file is created that
records
the name of each file and the number of records imported. Occasionally,
the
system just hangs. Like this morning, it imported 7 of 9 files but on the
eighth file, it stopped importing. The log recorded the file name but no
records were imported from that file. I'm wondering if there was a short
network disconnect, if that would cause this. No error is thrown - the
"Please wait while processs......" form just remains displayed.

My question is 2 fold, what might be causing this and if it is a network
communication issue, how can I capture the interruption?

Hope I have explained this thoroughly enough.
Thanks
LeAnn
Click to expand...

If it is caused by connectivity issues I would expect a runtime error to
occur. Does your code include error handling? If so perhaps worth reviewing
it to ensure messages are displayed in all cases or, for the purposes of
debugging, turn it off temporarily.

Ed Metcalfe.
 
I expected a runtime error too so a few weeks ago I turned error handling
off. Unfortunately no error was generated on this latest occurance.
 
Back
Top