hello,

I have to write a program that will run 7 days per week at 9.00pm and append the data to the 3 tables in SQL 2000.
Now i am not sure how to go about it.
I am at lost how to go about it using VB6.0
and write a stored proc tht will run 7 days per week at 9.00pm and also append to the 3 tables?
Pls can someone guide me and give a similar sample code?

Go to the Control Panel -> Scheduled Tasks, and add you program to start every day at 9PM

Marco

that can be done too ...
or for security purpose, you can create a key in your windows registry. You can made a key for your password too.And in your form_load event check for the values if the comparison is wright load it else end it, and do what you want to do.
Oh ya, put your program in startup key Run --- that will load your program automatically in startup.
hope this can help u
Alexis ...