Re: COMPACT COMMAND BUTTON

Article View: comp.databases.ms-access

Article #455

Back to comp.databases.ms-access Previous Next

#455

From: Martin Pascal-Murray
Date: Tue, 22 Jul 1997 00:00

17 lines
1435 bytes

Dear Tim,

You can't compact a database which is already open.  However, you could
write a macro in windows which will do this for you OR if you are good at
code, you could write code which will close the database, compact it and
then reopen it.  The trick lies in getting Access to pass the code over to
Windows, otherwise once it's let go of the database it will stop running.

Good luck!

TIMOTHY W. NEWTON <ENFORCER@PACBELL.NET> wrote in article
<01bc8c97$4b5d7e60$3475aace@adp547>...
> Does anyone know how to create a command button on a form to compact the
> database without have to leave it and use Accesses toolbar function.
> 
>

Technical Details

Message-ID: <01bc9675$65ab5ac0$a64711cb@martinm.wire.net.au>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <01bc8c97$4b5d7e60$3475aace@adp547>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101bdd,59d8f0d5f78be206
X-Google-Attributes: gid101bdd,public
X-Google-Thread: 111a5a,59d8f0d5f78be206
X-Google-Attributes: gid111a5a,public
X-Google-Thread: ff0ac,59d8f0d5f78be206
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 1034e6,59d8f0d5f78be206
X-Google-Attributes: gid1034e6,public
From: "Martin Pascal-Murray" <martinm@wire.net.au>
Subject: Re: COMPACT COMMAND BUTTON
Date: 1997/07/22
Message-ID: <01bc9675$65ab5ac0$a64711cb@martinm.wire.net.au>
X-Deja-AN: 258150381
References: <01bc8c97$4b5d7e60$3475aace@adp547>
Organization: A poorly-installed InterNetNews site
Newsgroups: comp.databases.ms-access,es.comp.bd.ms-access,microsoft.public.access.forms,microsoft.public.access.macros

Reply to Parent Message