E
-EvaMendes
How can I run a compact and repair mdb daily at certain time? Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Arvin Meyer [MVP]
-EvaMendes said:How can I run a compact and repair mdb daily at certain time? Thanks.
You can build an application in Access or VB which will do the compaction,
and run it using the Windows Scheduler, or any other program which allows
scheduling. You can also use FMS's Agent:
http://www.fmsinc.com/Products/Agent/index.html
E
-EvaMendes
HI,
If I am using access 97, how can I do it exactly? Can you please
give me some guideline or example? Thanks.
If I am using access 97, how can I do it exactly? Can you please
give me some guideline or example? Thanks.
A
Arvin Meyer [MVP]
Try this line of code:
DBEngine.CompactDatabase "c:\yourdir\oldname.mdb", "c:\yourdir\oldname.mdb"
You'll need to do it from another database which is open.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
DBEngine.CompactDatabase "c:\yourdir\oldname.mdb", "c:\yourdir\oldname.mdb"
You'll need to do it from another database which is open.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com