Re: Compacting a DB from the Builder

Article View: borland.public.cppbuilder.database.ado

Article #2478

Back to borland.public.cppbuilder.database.ado Previous Next

#2478

From: Mike Ruskai
Date: Wed, 28 May 2003 22:31

23 lines
1771 bytes

On Wed, 28 May 2003 14:47:41 +0200, Pär Buschka wrote:

>I want to compact an Access2000 database programmatically from within a
>program, using CppBuilder 6. I wonder if this is possible and in that case
>how to do it?

Follow the example given in the other response.  I also strongly suggest that
you compare the record counts in each table before copying the compacted
database over the original.  I've seen a couple of times in Access where
compacting truncated a large table to exactly 50,000 records.  I don't know
if it ever happens via ADO and Jet, but it's better to be safe.

--
 - Mike

Remove 'spambegone.net' and reverse to send e-mail.

Technical Details

Message-ID: <gunaalqrneguyvaxarg.hfmbx40.pminews@207.105.83.65>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!border3.nntp.aus1.giganews.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <3ed4afee$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,dbc094b16675290e
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-05-28 15:36:37 PST
Newsgroups: borland.public.cppbuilder.database.ado
From: "Mike Ruskai" <spamten.knilhtrae@begonedynnaht.net>
Message-ID: <gunaalqrneguyvaxarg.hfmbx40.pminews@207.105.83.65>
References:  <3ed4afee$1@newsgroups.borland.com>
Date: Wed, 28 May 2003 18:31:52 -0400 (EDT)
Reply-To: "Mike Ruskai" <spamten.knilhtrae@begonedynnaht.net>
X-Newsreader: PMINews 2.00.1205 For OS/2
Organization: TLF
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: Re: Compacting a DB from the Builder
NNTP-Posting-Host: 65.41.86.200
X-Trace: newsgroups.borland.com 1054161111 65.41.86.200 (28 May 2003 15:31:51 -0700)
Lines: 25
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!border3.nntp.aus1.giganews.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message