>Has something to do with the way record locking is handled using the 2^31 (2 GB) O/S limit. Do not expect this limit to be removed. MS will suggest anyone with this much data to use SQL Server. Another solution is to vertically split your data should it exceed the 2GB limit. There was an article a few years ago about the Eurotunnell that did just this to support 128 GB of VFP data.
>
>>Does anyone know the reason why the maximum physical size of a table is 2GB?
>>
>>Thanks in advance.
>>
>>Regards Michael
The article appeared in FoxPro Advisor, but I don't remember what year or month (
www.advisor.com for searches - most articles are not available online).
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
