[AccessD] Compact on close via code

Thanks for the replies guys - much appreciated.

Cheers Tracy

----- Original Message -----
From: "John Skolits" <JSkolits at CorporateDataDesign.com>
To: <accessd at databaseadvisors.com>
Sent: Friday, April 11, 2003 12:20 AM
Subject: RE: [AccessD] Compact on close via code


> You can find out what the checkbox is set to using the following.:
>
> Application.GetOption("Auto Compact")
>
> To set the flag on or off, use:
>
> Application.SetOption "Auto Compact", True
> Application.SetOption "Auto Compact", False
>
> There is another argument for the SetOption function called "Auto Compact
> Percentage" but I've never seen it work.
>
> You can get info if you search the online help for 'Compact', and select
> "Set Options from Visual Basic"
>
> John
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Tracy
> Sent: Thursday, April 10, 2003 4:22 AM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Compact on close via code
>
>
> Hi Listers
> I know theres a checkbox for compacting on close, but is there a code
> equivalent that can be put into an MDE file, my users have the runtime
> version of Access 2000, all bypassing of the startup options are disabled,
> so I need to put code into the close procedure of the mde.
> Can anybody help ?
>
> And also it must be without user intervention as happens when the compact
on
> close checkbox is checked.
>
> Thanks Tracy
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>