Just Need an idea

[sanford101]

I wrote an application that read a text file in the
certain folder and put the content into the sql server table

The application is running ok.
Now I want the application to run at backgroud at predetermined intervals. How can I do it?

Thanks for your help

[Bob Baddeley]

Well, first make the main form invisible or minimized. Then put in a timer. If you want the interval to be less than a minute, simply put the interval for that long. If you want it every ten minutes or something like that, try this:

Dim X

Private Sub Timer1_Timer() 'Set your interval to 60,000 (1 min)
X = X + 1
If X >= 10 Then
X = 0
'EXECUTE YOUR CODE
End If
End Sub

bob