On Jun 9, 9:52=A0am, "Steven Green" <gre...@[EMAIL PROTECTED]
> wrote:
> > However, the file sizes for the Paradox tables did not decrease like I
> > expected them to.
>
> deleting records from a paradox table does not reclaim the dead space..
>
> > =A0Is there a tool that I could use that would compact the tables to
ref=
lect
> > the new amount of data?
>
> there is a "restructure" process built into paradox (the software
package)=
> that packs the tables and indexes..
>
> if you will be working with paradox tables, you should use paradox, not
> access, to do it.. you can buy inexpensive older copies on my web site
> and/or on ebay..
>
> --
> Steven Green - Myrtle Beach, South Carolina USA
>
> Diamond Software Grouphttp://www.diamondsg.com/main.htm
> Paradox Sup****t & Sales
>
> Diamond S****ts Gemshttp://www.diamondsg.com/gemsmain.htm
> S****ts Memorabilia and Trading Cards
>
> "kryten" <Kryten98...@[EMAIL PROTECTED]
> wrote in message
>
> news:4e402de5-13ad-428e-83f9-f9435efa9a99@[EMAIL PROTECTED]
>
>
>
> >I have a legacy tool that uses Paradox database files. =A0There are
some
> > tables that are too large and I used Access to delete records from
> > them. =A0However, the file sizes for the Paradox tables did not
decrease=
> > like I expected them to. =A0Is there a tool that I could use that
would
> > compact the tables to reflect the new amount of data?
>
> > I know that Access has to be compacted on occasion because the objects
> > in the database keep their memory size even though data or code has
> > been deleted.
>
> > Thanks in advance for your response.- Hide quoted text -
>
> - Show quoted text -
I found Pdxrbld on www.rksolution.cz. It should take care of the
rebuild of tables, which is the primary need I have.
|
