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" <(E-Mail Removed)> wrote in message
news:039301c33eba$7d09a890$(E-Mail Removed)...
> 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" <(E-Mail Removed)> escribió en el mensaje
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:039301c33eba$7d09a890$(E-Mail Removed)...
> > 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
>
>