Access macro to compact and repair


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.

Ken Snell

Create a macro to do what you want, and name it AutoExec. ACCESS will run
that macro automatically when a datatbase file is opened.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question