5 Invalid Procedure Call or Argument

[GLT]

Hi,

I have some VBA code that scans through some remote servers and reads backup
logs.

It works well, except when it scans one particular server, then I get the
following error:

5 Invalid Procedure Call or Argument

It does not ask me if I want to debug the code so I have no idea what is
causing this.

To make matters worse, I hardcoded the server that has this problem so that
the VBA code only processes this server (but does it many times over).

If I run it via the debuging window and step through the code, press F8 it
processes this server over and over perfectly.

If I run the code normally, it processes this server only once then fails
with this error.

Can anyone give me an insight as to what might be causing this, and how I
can trap this error?

Any help is always greatly appreciated...

Cheers,
GLT.

 

[Roger Carlson]

Not a ton of help here, but since it runs in debug mode and not in standard
run mode, I'd guess there's some kind of timing issue. Might help you
narrow the field of possibilities some anyway.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L