Re: How can I purge deleted records?

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

Article #5867

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

#5867

From: Jerry Bloomfield (TeamB)
Date: Thu, 21 Dec 2000 01:34

19 lines
1629 bytes

On Wed, 20 Dec 2000 16:41:20 +0330, "M. Norouzi Eghbali"
<Galaxy@Irandoc.ac.ir> wrote:

>How can I purge deleted records using Access database and free their space?
>I am using Microsoft Jet 4.0 OLE DB Provider.
>Any help is so pleased.

You need to find the OLE DB call which performs the "compact" functionality
on the MDB file.

Be aware that his function call needs exclusive access to the MDB file
while it is working,  so you will need to close all other connections to
the MDB file except the one performing the compaction.

Jerry Bloomfield (TeamB)
-- 
http://www.teamb.com                                      JersWork@wwa.com
Please do *NOT* send private e-mail without prior permission (my anti-spam 
filters will probably just delete it anyway <g>)

Technical Details

Message-ID: <ldn24t80ude1iobm4oq4imngqhkmbrsn2k@4ax.com>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!newsfeed.online.be!newsfeeds.belnet.be!naxos.belnet.be!news.belnet.be!bornews.borland.com!not-for-mail

References: <3a40b057_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,453e4cf5d6a6d3a5
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2000-12-20 17:41:01 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!newsfeed.online.be!newsfeeds.belnet.be!naxos.belnet.be!news.belnet.be!bornews.borland.com!not-for-mail
From: "Jerry Bloomfield (TeamB)" <JersWork@wwa.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: How can I purge deleted records?
Date: Wed, 20 Dec 2000 19:34:06 -0600
Organization: LSVFA - Latest Software Version Freaks Anonomous
Lines: 19
Message-ID: <ldn24t80ude1iobm4oq4imngqhkmbrsn2k@4ax.com>
References: <3a40b057_1@dnews>
NNTP-Posting-Host: 157.238.74.72
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Newsreader: Forte Agent 1.8/32.548

Reply to Parent Message