'Permission denied' not catched in ErrorTrap

[sngsc6]

Hello,

I try to move a file which was created by an external batch-file. However sometimes the newly created file is not 1005 there yet, on the moment Access tries to move this file.
This might have to do with other processes on that computer (Outlook is checking Emails, internet pages are refreshed, etc).

To prevent unnecessary waiting-time, I did try to catch that 'Permission denied, Run-time error 70'-error into the 'On Error GoTo' function.
However, I do not succeed. The error is still shown on screen although the Error-trap should take another second 'Pause-time' before retrying the MoveFile command.

The script is as follows:


Private Sub StartProc_Click()



............


If Not rs.BOF And Not rs.EOF Then rs.MoveFirst
While (Not rs.EOF)


............


Call Shell(BatchFile, vbHide)


BatchFile:
On Error GoTo ErrTrap

TNow = Time
TWait = DateAdd("s", 1, TNow)
Do Until TNow >= TWait Or TNow - TWait < -0.05
TNow = Time
Loop

............

CopyFrom = [Forms]![DB - 05 - Create KAP bestanden]![ConversionMap] & "" & rs1.Fields("Map-name") & ".KAP"
CopyTo = [Forms]![DB - 05 - Create KAP bestanden]![KAPStore] & ""

On Error GoTo ErrTrap
fso.MoveFile CopyFrom, CopyTo



GoTo NextItem:

ErrTrap:


Resume BatchFile

End Sub



Can somebody explain, why the error-trap is letting me down?

Thanks on forehand

[moke123]

Have you debug.print your file paths to see if they are valid and that you have permissons to access them.

Have you tried DoEvents or a Sleep/ wait procedure? https://www.fmsinc.com/microsoftacce...idDoEvents.asp

[sngsc6]

Hello moke123,

Have you debug.print your file paths to see if they are valid and that you have permissons to access them.

Have you tried DoEvents or a Sleep/ wait procedure? https://www.fmsinc.com/microsoftacce...idDoEvents.asp

No, I did not Debug.Print the file-path, but lots of times it goes fine. Only when the HD of the computer is also doing something else, it takes longer for the batch-file to finnish.
When the error comes up, and I press 'Debug', followed by F5 (Continue script), it goes fine as well.

The reason for doing this via the errortrap, is that lots of times the system is only requiring one second for the batch-file to finnish. But just in case the HD is busy, it is requesting some extra time.
Building that time into the script by default, it makes the whole procedure unrequired and unnecessary long. The total procedure can have loops of more that 1000 times, so every second counts.

So I am looking for the reason, why the 'Permission denied'-error is not trapped in the error-trap procedure.

Regards,

[pbaldy]

Post 3 was moderated, I'm posting to trigger email notifications.