>>For some documentation, I need to calculate the number of records that a given table would need to have in order to hit the 2G file size limit.
>>
>>My formula so far is
>>
>>nSizeOfEmptyTable + 2*(2^30)/nRowWidth
>>
>>Is there anything I'm missing, doing wrong, etc?
>>
>>TIA
>
>Shouldn't that be:
>
>((2**31) - nSizeOfEmptyTable) / nRowWidth
>
>
>Don't forget that a row consists of one extra character for the DELETED status.
Yep, I get nRowWidth from the Table Designer | Table tab, so it already includes the delete status.
I should have mentioned that.
Good catch. Basic algebra - 2^31 ... duh
Thanks.
Insanity: Doing the same thing over and over and expecting different results.