MS Access database support - How to interrogate through OLEDB for space to be freed by compaction?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

How to interrogate through OLEDB for space to be freed by compaction?

Riley DeWiley

2005-07-28, 1:39 pm

There is a way to ask a data source how much space would be freed if
compaction were to be done. I saw the reference, but now cannot find it.

Anyone know where that web page was? Even Google has not helped.

RDeW

polite person

2005-07-29, 3:25 am

On Thu, 28 Jul 2005 12:16:09 -0700, "Riley DeWiley" <riley.dewiley@gmail.com> wrote:

>There is a way to ask a data source how much space would be freed if
>compaction were to be done. I saw the reference, but now cannot find it.
>
>Anyone know where that web page was? Even Google has not helped.
>
>RDeW
>
>
Google helped me - searching for ...space freed compact ole
I found
http://msdn.microsoft.com/library/d...jetprovspec.asp
as the first hit.

Jet OLEDB:Compact Reclaimed Space Amount
(DBPROP_JETOLEDB_COM
PACTFREESPACESIZE)

(connect first)

Amazing!

Sponsored Links