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

Jim Dettman jimdettman at verizon.net
Tue Jan 29 14:24:28 CST 2008


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




More information about the AccessD mailing list