In article <4292f064$
XXXX@XXXXX.COM >,
XXXX@XXXXX.COM says...
Quote
The database has about 6350 records in it,
That is definitely not too much, depending of course on the size of the
binary-field.
Tell your customer to look for a file with the same name as your table,
but with suffix "dbt". This file holds the BLOb-Data for your table
("dbf"), while indexes are kept in "mdx". Size of dbt will be important.
Quote
up I'm not really sure how to check table levels...
if the table is created on the site of your customer, it will most
likely have the level which is set as default in the BDE.
In BDEAdmin.exe, check for "configuration/drivers/native/dbase: LEVEL"
Quote
restructure the table because I get an "Insufficient disk space" when
check also if you are victim of the 4GB-Bug in BDE, search this NG for
topic "4GB"
Quote
The problem occurs when inserting data in the table,
So, records and BLObs only get appended, not deleted, and most of all:
not changed?
When changing a BLOb, the old value does not "vanish". The new value is
usually added at the end of the file; the header (for the main record)
will get a new pointer to the new location. The garbage is cleaned ONLY
by copying and reappending the records, or by using PACK.
Deleting will not help, because dBase-tables have a deleted flag for
every record and you can "recover" deleted records until the next
housekeeping-run.
How many users do you have on that "problem"-site?
Network-locking-conflicts can lead to so-called "Bloats" of BLOb-fields,
where size of dbt-files is increasing overproportionally.
--
ciao,
Andr?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Deutsche dBase-Konferenz dBKon 2005 ::: 11. bis 13. November 2005
Deutschsprachige Konferenz zu dBase und anderen Datenbanken
Info:
www.dbase-konferenz.de