>>>>I'm at a loss, I'm afraid. If I could see the table I might be able to figure it out, but that's too large to email. :) Isn't that too large to even work? I though VFP tables couldn't get bigger than 2GB? I may be wrong on that.
>>>>
>>>>Maybe someone else will jump in here with an idea?
>>>
>>>yup, that's what the msdn library says:
>>>Maximum size of a table file 2 gigabytes
now, maybe that's the problem vfp gets puzzeld/confused and messes up the sizes? i mean 2.1 gb - that shouldn't be possible. and i think that limit is possed on all files attached to the .dbf. wiered - to say the least.
>>
>>I think there might be a confusion here between gigabytes and billions of bytes. That makes a difference of ca. 7%. 2 GB is exactly 2147483648 bytes (somewhat more than 2.1 billion).
>
>that's very possible, but as you probably already saw, he corrected himself, he was talking about the database size - not table size.
But a database in vfp
is a table.
Alan