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

Thanks for your help!!

**************************************************
* 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 Jim Dettman
> Sent: Tuesday, January 29, 2008 03:24 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] OT: FOXPRO compact decrease dbf size - 
> important
> 
> Patti,
> 
>   You want to use the PACK or PACK DATABASE command.
> 
> Jim. 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> O'Connor, Patricia (OTDA)
> Sent: Tuesday, January 29, 2008 1:30 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] OT: FOXPRO compact decrease dbf size - important
> 
> 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
> 
>