Program to run at certain time
Here is what I need to do:
My program needs to run at a certain time when no one will be connected to the database (ie. midnight), and compact and repair it.
How can I make it so that the program will run at a specified time every day?
I can check the db for users who are connected,
and...I'm still trying to figure out the compact and repair thing... I have the zip file from the other thread from here-> http://www.freevbcode.com/ShowCode.Asp?ID=1024
I'm trying to figure out if I can just run that .exe using command line arguments or something to tell it the database to compact ( i know it does this), as well as the workspace (dont know if it can), and whatever else it would need.
but..I guess the main thing would be getting it to run at a certain time!
Any help is appreciated!
Thanks in advance
Visual Basic 6.0
Microsoft Access 2003