How to automatically perfirm Repairing & Compression instruction

[accesser2003]

Is there a VB code that I can use to automatically compress and repair the database?

 

[ajetrumpet]

i believe the code is:

application.compactrepair

 

[Alansidman]

Take a look at this video. It may solve your issue.

http://www.datapigtechnologies.com/flashfiles/schedulecompact.html

Alan

 

[boblarson]

or some code here:
http://www.btabdevelopment.com/main/CodeSnippets/tabid/104/Default.aspx