O'Connor, Patricia (OTDA)
Patricia.O'Connor at otda.state.ny.us
Tue Jan 29 12:29:47 CST 2008
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.