Running Compact and Repair from a Macro ?

[ncopeland]

Hi

Is it possible to run "Compact and Repair" from a macro or a bit of VB code?

KR

NC

 

[Remou]

Have you seen:
Compact and Repair automatically at the start of each day
faq705-4998

 

[ncopeland]

Hi

I have seen this. It is a multi user database application that I have written. I would like them to run this when everybody is off the app not just when 1 person closes the app or starts up the app.

Any help greatly received.

KR

NC

 

[willybgw]

You can create a shortcut that will compact the database using the following format.

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "FULL PATH\DATABASE NAME.mdb" /COMPACT

willybgw

 

[mp9]

Considering scheduling your db admin tasks: the Handy Access Launcher may be of interest,

http://www22.brinkster.com/accessory/resources/001.shtml

 

[falk72]

Been trying to figure this one out also. I have a multi user enviroment and a database with a "Main" table of 15,000 records and two of the several other tables have 49,000 and 130,00 and need to make sure that everything is as small and running as fast as possible. we have to tun our systems off at night so i can't have it run wehn noone is here. any help on this would be great.