Access macro to compact and repair

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.
 
K

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

Similar Threads

Compact & Repair, Open table, close table, then run macro 3
Compact & Repair 4
Coding a macro to compact and repair several external databases 1
RUNCOMMAND Repair and Compact? 3
Compact and Repair macro 1
Can I run a macro to Compact and Repair the database. 1
Access Deleted Table after Compact and Repair Database (Access 2010) 0
Access Access, Error Due to Versioning Differences 0

Top