Arthur Fuller
fuller.artful at gmail.com
Tue Jan 29 13:15:03 CST 2008
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 >