Access macro to compact and repair

  • Thread starter Thread starter Tony O
  • Start date Start date
T

Tony O

I have a Microsoft access database that I would like to compact and
repair overnights once a week.
I know that I can use the scheduler in Microsoft.

How do I get Access to run a query within Access unattended? Do I
need to have a macro?
Please advise.
 
Create a macro to do what you want, and name it AutoExec. ACCESS will run
that macro automatically when a datatbase file is opened.
 
Back
Top