how can i solve it?

Hello Experts,
i got the same error "runtime error 35764 the connection is still on execution"
i am usgin a my ftp connection application and it send my file one by a timer funciont
any idea where is the cause?
aitsu01Asked:
Who is Participating?
 
3_SConnect With a Mentor Commented:
you should disable the timer when it start the routine
timer.enable = false
and
timer.enable = true
when the routine is finished

between you set the code for your ftp connection

If you do not disable the timer and the routine takes longer to run than the time set for the timer the timer will start the routine several times (every time the interval of the timer is reached)
0
 
Barry62Commented:
what is the code?
0
 
aitsu01Author Commented:
Hello Experts,
well it seems solved now
i will attach here the problem's code:

BEFORE:
Private Sub Timer1_Timer()
Kill "c:\lmyfile.txt" " the ftp application was still on execution on the text file"
 Load my function
----------------------------------------------------------
AFTER

Private Sub TimerHook_Timer()

On Error Resume Next " it will be ignored"
Kill "c:\myfile.txt"
 Load myfuncion

this solution can be a bit dirty but it works,anyway i listen new more suitable solutions
for example now the problem that the new text file willl append at ever ftp sending with the old text file content,so it will be pretty big after.any good advice?Thank you ina dvance

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.