AppendChunk and clearing the binary field

Using Visual Basic 6 we are using:

MainRs.Fields(ColName).AppendChunk buffer
MainRs.Update

to append binary files to Access 97 and this works ok.

The problem is that when trying to empty the field with:

MainRs.Fields(ColName).AppendChunk ""
MainRs.Update

The field does empty and from Access I can
find the field truly empty, but the file size does
not decrease accordingly?

Thanks,

Johannes

Insert binary data into Access DB expand file size quickly (depending on the
binary file size, of course), the file size will not shrink when data is
deleted from database unless you do database compacting.

If lot of data is added to and deleted from the database very often, you
need to compact the database regularly.

"ftec" ftecatkolumbusfi wrote in message
...

Using Visual Basic 6 we are using:

MainRs.Fields(ColName).AppendChunk buffer
MainRs.Update

to append binary files to Access 97 and this works ok.

The problem is that when trying to empty the field with:

MainRs.Fields(ColName).AppendChunk ""
MainRs.Update

The field does empty and from Access I can
find the field truly empty, but the file size does
not decrease accordingly?

Thanks,

Johannes

Thanks!

"Norman Yuan" wrote in message
...
Insert binary data into Access DB expand file size quickly (depending on
the
binary file size, of course), the file size will not shrink when data is
deleted from database unless you do database compacting.

If lot of data is added to and deleted from the database very often, you
need to compact the database regularly.

"ftec" ftecatkolumbusfi wrote in message
...

Using Visual Basic 6 we are using:

MainRs.Fields(ColName).AppendChunk buffer
MainRs.Update

to append binary files to Access 97 and this works ok.

The problem is that when trying to empty the field with:

MainRs.Fields(ColName).AppendChunk ""
MainRs.Update

The field does empty and from Access I can
find the field truly empty, but the file size does
not decrease accordingly?

Thanks,

Johannes