Is there any known problem with using BDE to access or write databases
past 2Gb. I know there is a problem with individual tables of that
size but we have a system which creates databases which can be in
excess of that size by writing the data into multiple dated tables.
However we have discovered a problem! When the total of the data in
the data directory reaches almost, but not quite, 2Gb there appears to
be a chance that it will not be possible to write further data to the
database due to 'insufficient disk space' errors even though there is
more than sufficient disk space. There is no problem with having a
database larger than this as we can copy one of the older tables to
force the directory to contain >2Gb and then restart everything and
the database continues to grow normally, it's just getting past that
More curiously it does not appear to be dependent on the open tables
(our system rarely has more than one or two tables open at a time,
perhaps 200 or 300Mb at most) and does not appear to depend on the
directory in which the data resides (we have seen the problem when the
size of d:\data + d:\data\temp reached 2Gb).
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