I am having a problem with one vfp table
The has happened just since the size of the table has gone over 1Gig
(# records only in millions) and with a CDX file of 1/2 Gig (no FPT)

I seem to recall something in earlier versions about size limit of 1 Gig
if there is an index file ??

can anyone remember what ?

al

Re: system capacities by Fred

Fred
Sun May 21 01:11:18 CDT 2006

Not that I'm aware of. The limit is 2 GB, not 1GB. Do you have a memo file
(.FPT), that may have gone over the 2 GB limit? The 2 GB limit is per file,
so you can have up to a 2 GB .DBF, .CDX, and .FPT for nearly 6 GB. None of
the parts can exceed the 2 GB limit.

--
Fred
Microsoft Visual FoxPro MVP


"Al Marino" <amarino_AT_galaxymusic_DOT_com> wrote in message
news:eVmxA%23AfGHA.2076@TK2MSFTNGP04.phx.gbl...
>I am having a problem with one vfp table
> The has happened just since the size of the table has gone over 1Gig
> (# records only in millions) and with a CDX file of 1/2 Gig (no FPT)
>
> I seem to recall something in earlier versions about size limit of 1 Gig
> if there is an index file ??
>
> can anyone remember what ?
>
> al
>
>



Re: system capacities by Al

Al
Mon May 22 09:06:07 CDT 2006

Fred
Thanks for reply
Maybe I am remembering some other language (dbase ?, talk about old <g>)
if I get bored, I may go back to old books in closet and look it up

al

"Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
news:%236bjr0JfGHA.2068@TK2MSFTNGP02.phx.gbl...
> Not that I'm aware of. The limit is 2 GB, not 1GB. Do you have a memo
> file (.FPT), that may have gone over the 2 GB limit? The 2 GB limit is
> per file, so you can have up to a 2 GB .DBF, .CDX, and .FPT for nearly 6
> GB. None of the parts can exceed the 2 GB limit.
>
> --
> Fred
> Microsoft Visual FoxPro MVP
>
>
> "Al Marino" <amarino_AT_galaxymusic_DOT_com> wrote in message
> news:eVmxA%23AfGHA.2076@TK2MSFTNGP04.phx.gbl...
>>I am having a problem with one vfp table
>> The has happened just since the size of the table has gone over 1Gig
>> (# records only in millions) and with a CDX file of 1/2 Gig (no FPT)
>>
>> I seem to recall something in earlier versions about size limit of 1 Gig
>> if there is an index file ??
>>
>> can anyone remember what ?
>>
>> al
>>
>>
>
>