While a little more complicated than a simple .cmd file one option is to create a small ACT SDK Framework application that performs database maintenance when launched. Then place this in the windows startup folder.
Example:
//When the program is launched from Windows Startup and the form is loaded we perform our maint.
private void Form1_Load(object sender, EventArgs e)
{
ActFramework ActFwk = new ActFramework();
//Log on to the database you perform operations too
//Lots of ways to set this depending on how complicated you want to get
//Right now just hard-coded to perform maint. on the ACT12Demo.pad
ActFwk.LogOn(@"C:\Documents and Settings\All Users\Documents\ACT\ACT for Windows 12\Databases\ACT12Demo.pad",
"Chris Huffman", "");
try
{
//Lock DB for maint
ActFwk.Database.LockDatabase(DatabaseLockReason.General);
//Do repairs
ActFwk.CheckDatabase();
ActFwk.ReindexDatabase();
ActFwk.RepairDatabase();
//Unlock
ActFwk.Database.UnlockDatabase();
//Some sort of dialog to indicate finished
MessageBox.Show("Completely Done!");
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString());
//Important to unlock database if Exception is encountered!!!
ActFwk.Database.UnlockDatabase();
}
}
Hope this helps,
Message Edited by Carlton_Jones on 04-14-2009 03:23 PM
Message Edited by Carlton_Jones on 04-14-2009 03:24 PM
Carlton Jones
Sage Software
