>>> (this offset is one of the reasons for the 2 GB limit on file size). <<
>
>2 GB is simply the maximum value of a signed 32 bit integer (2**31). It is a limitation of the FAT file system.
>
>Mike
Mike,
Yes but the reasoin it is still a,.limt on VFP table sis the lock offset that VFP uses which is a 32 byte integer from the actual location so if a vfp table grew beyond the 2 gb barrier then the lock on record one could be hitting the location of another record in the table. When the tables are kept below 2 gb then the locking offset can never hit another record in the table becuase the table cannot grow to size big enough to allow that.
This is not a guess on my part but information I learned from the VFP developers.