Re: Compact & Repair Database by VBA Code??

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 news:5A07F4F2-F9E6-4A52-852B-56E783E62329@xxxxxxxxxxxxx,
Gary typed:
Can I perform the menu operation of compact & repair
database
using VBA code??

Thanks,

Gary


.

Relevant Pages

  • Re: Designing a counter
    ... http://www.mrcomputersltd.com/ Repairs Upgrades ... DoCmd.RunSQL "UPDATE tblCountOfStartYearChanged SET ... "Nick Coe " wrote: ... DoCmd.SetWarnings True 'Turn warnings back on ...
    (microsoft.public.access.formscoding)
  • Re: Buttom for Linked Table Manager
    ... Nick Coe ... AccHelp v1.01 Access Application Help File Builder ... Download Free Copy ...
    (microsoft.public.access.formscoding)
  • Re: Conflicting Record Problems
    ... So your unique index is on Leave Date? ... >> Nick Coe ... >> http://www.pjandcoe.co.uk/ Online Store ... >> http://www.mrcomputersltd.com/ Repairs Upgrades ...
    (microsoft.public.access.modulesdaovba)
  • Re: Buttom for Linked Table Manager
    ... "Nick Coe " wrote: ... These books are worth every penny! ... > AccHelp v1.01 Access Application Help File Builder ...
    (microsoft.public.access.formscoding)
  • Re: AccHelp future development - discussion please
    ... I'm with Billy Connelly on the tosser bit though. ... Available - Will work for money :-) ... http://www.alphacos.co.uk/ AccHelp + pAnimal ... > Nick Coe wrote: ...
    (comp.databases.ms-access)