A
Alan
I would like to set somw databases to compact & repair when a form is opened
(using a macro that opens the form from the task scheduler). I tried the
following code on form load but it wants to create a new table. instead of
running compact & repair:
Private Sub Form_Load()
DoCmd.DoMenuItem acForm, acTools, acDatabaseUtilities,
acCompactAndRepairDatabase
End Sub
Any Ideas?
Thanks,
Alan
(using a macro that opens the form from the task scheduler). I tried the
following code on form load but it wants to create a new table. instead of
running compact & repair:
Private Sub Form_Load()
DoCmd.DoMenuItem acForm, acTools, acDatabaseUtilities,
acCompactAndRepairDatabase
End Sub
Any Ideas?
Thanks,
Alan