Is there any known problem with using paradox databases of more than
2Gb. I know there is a problem with individual tables of that
size but we have a system which creates multiple tables of about 200 -
300Mb to produce a total database of in excess of 2Gb.
However we have discovered a problem! When the total data in reaches
almost, but not quite, 2Gb it appears to be impossible to get past the
2Gb boundary, we apparently get 'insufficient disk space' errors even
though this is on a Raid with about 50Gb free. We can get past the
limit by copying a file to force the directory / data over 2Gb at
which point we just carry on as before but now we have found the same
problem at 6Gb (looks like someone use a signed 32bit integer for some
It is not dependant on the open tables and does not appear to depend
on the directory in which the data resides (we have seen the problem
with the 2Gb spread across two directories). It also doesn't seem to
relate to the drive size or usage.
Has anyone out there encountered anything similar? Can this be
explained? Can it be solved? At present our only solution is to wait
until we reach 2Gb and the system stalls at which point we copy a
table to force the data past 2Gb and restart. This is all implemented
using Delphi3, BDE 5.01 (or BDE 4.51) and Paradox 7.
Thanks in advance for any suggestions.
Jarvis N. Brand