Re: Compact Database

You can write code to compact the back end, assuming all connections from
your front-ent are closed (including any bound forms). However, you can't
compact the front end from one of its forms while it's open.

--
Timothy C. Doherty
Senior Systems Architect
Destination Technologies, Inc.
www.planology.com


"Vichet Chea" <VichetChea@hotmail.com> wrote in message
news:039301c33eba$7d09a890$a301280a@phx.gbl...
> I want to code one function that compact Back-end and
> Front-end database at one time. And i the Function must
> be on the form of Front-End.
>
> Thank you

Hi Timothy,

"However, you can't compact the front end from one of its forms while it's
open. "

In A2k or AXP you can use just one line of code to do that. Have a look at

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


--
Saludos desde Barcelona
Juan M. Afan de Ribera
<MVP Ms Access>


"Timothy C. Doherty" <tim@planology.com> escribió en el mensaje
news:vg16oaa56rhiae@corp.supernews.com...
> You can write code to compact the back end, assuming all connections from
> your front-ent are closed (including any bound forms). However, you can't
> compact the front end from one of its forms while it's open.
>
> --
> Timothy C. Doherty
> Senior Systems Architect
> Destination Technologies, Inc.
> www.planology.com
>
>
> "Vichet Chea" <VichetChea@hotmail.com> wrote in message
> news:039301c33eba$7d09a890$a301280a@phx.gbl...
> > I want to code one function that compact Back-end and
> > Front-end database at one time. And i the Function must
> > be on the form of Front-End.
> >
> > Thank you
>
>