Compact and Repair Code 1

[Steven547]

Does anyone know or have any code so when the user clicks a command, it will "compact and repair" the DB? I ask this, because we are running this off a server, so If I have this set to "compact" on close, it takes forever. So I would like to do this on a "user" basis...

thanks.

 

[PHV]

Have a look here:

http://www.mvps.org/access/general/gen0041.htm

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886