file too large

[Jeff Harrison]

>From: "scooter6 at gmail.com" <scooter6 at gmail.com>
>To: Jeff Harrison <jeffaharrison at yahoo.com>
>Cc: filePro Mailing List <filepro-list at lists.celestial.com>
>Sent: Thu, February 3, 2011 5:07:35 PM
>Subject: Re: file too large
>
>
>  Well, the reason is our 'archive' file is fairly large in size as well.
>  My end result needs to be the most recent 6 months will be in the orig file 
>that is over 2GB right now.....
>  My archive file will hold approx the previous year - and a third file I was 
>planning on building will have some older stuff
>  Because of legal issues, etc we have to retain all these notes - we can't 
>permanently delete things until they're over 4 yrs old
> 
>  

I am suggesting that you create an additional - new - archive file.  Per my 
suggestion you would not be permanently deleting anything - ALL the records 
would still be in your hldkey and hlddata - as long as you do not delete them.  
You can recover them at a future date at your leisure.

Yes, my suggestion would give your the most recent 6 months in your original 
file - but all the records would still exist in hldkey and hlddata.

Jeff Harrison
jeffaharrison at yahoo.com
Author of JHImport and JHExport.