Estimate space freed up by compacting MS Access

Forgive me if this has been asked before: Is there any way of estimating the
amount of space that will be freed up by doing a compact on an MS-Access
database (without actually doing the compact)?

My reason for asking is that we have an application that uses an access
database. Rather than compact it each time we start or stop the application
(because I would rather avoid the delay), I would like to compact it when
the amount of reclaimable space goes over (say) 30%. Is this possible?

If its relevant, I'm currently using TAdoConnection to connect to the
database, and TJetEngine to compact it.

Thanks in advance.
--
Brian Cryer
www.cryer.co.uk/brian


.

Relevant Pages

  • Re: Removing None objects from a sequence
    ... Your goal should be clarity of code, not saving keystrokes. ... Writing something that is compact in terms of the amount of code to write does not mean its function is clear or even that it is more efficient to run, ...
    (comp.lang.python)
  • Re: [PATCH 01/32] Add an ERR_CAST() macro to complement ERR_PTR and co. [try #2]
    ... It's shorter, more compact, and of course requires the least amount of change ... (especially as I can automate it with a command line perl script). ...
    (Linux-Kernel)
  • Re: How to find Size of tables in Database
    ... amount of "wasted" space which will be recovered when you compact. ... and then compacting the database; what use is it to know how many bytes it's ... taking up within the Access database? ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Importing A Lot Of Data
    ... Nanette wrote: ... You could try simulating the amount of data you might have and see where it leaves you. ... For what it's worth, I have a database with some 4 million records, 8 columns and it's just fine. ... (Takes forever to compact, but that's another story...) ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Estimate space freed up by compacting MS Access
    ... MS-Access database (without actually doing the compact)? ... My reason for asking is that we have an application that uses an access ... compact it when the amount of reclaimable space goes over 30%. ...
    (borland.public.delphi.database.ado)