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.

--

Ken Snell
http://www.accessmvp.com/KDSnell/


"Tony O" <(E-Mail Removed)> wrote in message
news:ca874839-ffb0-4fe6-8a27-(E-Mail Removed)...
>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.