Windows 2000 2 GB file limit

[Bill Vermillion]

In the last exciting episode of the filePro saga, 
Don Coleman was heard to say:" 
if: Thu, Nov 04 14:03  
then: nm = Don Coleman 
if:
then: show nm < "said:"  
Don Coleman said: 

> Fairlight wrote:
> 
> >Only Kenneth Brody would say something like:
> > 
> >
> >>Don Coleman wrote:
> >>[...]
> >>   

> >>>evening.  Last night the key file the reached Microsoft 2GB file size
> >>>limit which stopped the archive process.  I renamed the file temporarily
> >>>and set up a new key file and ran the archive process this morning but
> >>>would like to access the now-unavailable archived key.  I can obtain
> >>>Tuesday night's key file from their backup but would still potentially
> >>>be missing some data from Wednesday.  Does anyone have any suggestions
> >>>on how to allow filePro to access this key file.

> >>[...]

> >>Use extended key files -- key, keyx1, keyx2, and keyx3.

> >Out of curiosity, define "use". touch/chown/chmod? Or is there
> >something more to it? You'd think if fP has the ability to use
> >them, it would create them on its own, so I'm wondering what
> >you mean by "use".

> >Do they supplement the main key, or replace it?

> By "use" I mean access via filePro. Ideally I would like to
> be able to delete several records to get the file size below
> the MS limit (~2GB). At this time fP nor any other MS based
> programs can access the file including a both hex and text
> editors.

Did you notice Nancy's reply that the 2GB+ limit will be fixed in
filePro 6.0.  

If you are using NTFS as the filesystem MS has a 16 Terabyte file
size limit.   And I think the FAT 32 is a 4GB file size limit.

> I know that deleting several records will not reduce the actual
> file size until that space is reclaimed. That will be the next
> challenge. I was hoping to delete the last several records with
> my hex editor but it is unable to open the file. I do need to
> be able to view and access this data occasionally.

You'd have to rebuild the file as deleted records will be available
for new records to be written in them.  If you use a hex editor to
shorten the file you will probably open a can of worms that you
might never recover from.  

If you need to add data, you could just remove some of the records
and FP will automatically re-use that space.

You could run a process to archive a goodly share of those records
to another file that has a mirrored structure and access that file
for older records [as an example].

Bill
-- 
Bill Vermillion - bv @ wjv . com