How can I purge deleted records?

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

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by M. Norouzi Eghbali Wed, 20 Dec 2000 13:11

#5868

Author: M. Norouzi Eghbali
Date: Wed, 20 Dec 2000 13:11

8 lines
1078 bytes

Hi,

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.

regards,
M. Norouzi

Re: How can I purge deleted records?

#5867

Author: 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>)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads