Compact & Repair Database by VBA Code??

[Guest]

Can I perform the menu operation of compact & repair database using VBA code??

Thanks,

Gary

 

[Nick Coe \(UK\)]

It is doable, try these links for some info:

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

http://www.mvps.org/access/bugs/bugs0045.htm

If you're using A97:
http://www.mvps.org/access/modules/mdl0030.htm



--
Nick Coe (UK)
http://www.alphacos.co.uk/ AccHelp + pAnimal
http://www.mrcomputersltd.com/ Repairs Upgrades

In Gary typed:

 

[Guest]

Is there a variant of this that can also be used to perform the menu
operation of Back Up Database? I have a function I use twice a day to
import data from a non-Access database, and I always have to compact it
afterward, and I back it up once a day. If I could make this part of the
function, it would be awsome!