[AccessD] OT: FOXPRO compact decrease dbf size - important

Thanks Arthur
I did try the REINDEX and that definitely cut the size down. I had tried
the PACK but wasn't sure whether I had coded it correctly - will try
again - though it could just be there is nothing to delete.

It is a shame they don't have a similar compact like Access.  

BTW - if anyone else sent a reply from 1:30 EST yesterday to 10:30 AM
est today - I did not receive it...Not sure whether it was our email or
the DatabaseAdvisors who was not sending/receiving

Thanks

**************************************************
* Patricia O'Connor
* Associate Computer Programmer Analyst
* OTDA - BDMA
* (W) mailto:Patricia.O'Connor at otda.state.ny.us
* (w) mailto:aa1160 at nysemail.state.ny.us
**************************************************
 

> 
--------------------------------------------------------
This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments.  Please notify the sender immediately by reply e-mail and delete the e-mail from your system. 


-----Original Message-----

> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Arthur Fuller
> Sent: Tuesday, January 29, 2008 02:15 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] OT: FOXPRO compact decrease dbf size - 
> important
> 
> To my knowledge there is no compaction available. best you can do is
> 
> USE aTable
> PACK
> and repeat for all tables. This will help only if records 
> have been marked for deletion and the table was not packed.
> 
> As for indexes, use all the indexes related to each table 
> (one table at a
> time) and issue:
> 
> USE aTable INDEX idx1, idx2, etc.
> REINDEX
> 
> hth,
> Arthur
> 
> On 1/29/08, O'Connor, Patricia (OTDA) 
> <Patricia.O'Connor at otda.state.ny.us>
> wrote:
> >
> > HI ALL
> > Is there a way to COMPACT / SHRINK the size of a FOXPRO database 
> > and/or table
> >
> > I know this is OT but I have tried google and can't seem to find 
> > specifics for FOXPRO If you have any exes, commands, macros, sites  
> > etc it would be greatly appreciated.
> >
> > We just inherited a FOXPRO database and are trying to do 
> the monthly 
> > update several of the tables dbf and indexes (CDX) are very 
> near the 
> > 2g point.
> >
> > In ACCESS you can compact the database and shrink the size.
> > I have reindexed which shrunk the CDX but how can I do the table.
> >
> > Thanks
> > Patti
> >
> > **************************************************
> > * Patricia O'Connor
> > * Associate Computer Programmer Analyst
> > * OTDA - BDMA
> > * (W) mailto:Patricia.O'Connor at otda.state.ny.us
> > * (w) mailto:aa1160 at nysemail.state.ny.us
> > **************************************************
> > --------------------------------------------------------
> > This e-mail, including any attachments, may be confidential, 
> > privileged or otherwise legally protected. It is intended 
> only for the 
> > addressee. If you received this e-mail in error or from someone who 
> > was not authorized to send it to you, do not disseminate, copy or 
> > otherwise use this e-mail or its attachments.  Please notify the 
> > sender immediately by reply e-mail and delete the e-mail 
> from your system.
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>