Blobs in Access

message from John K. on 2 Jun 2004

we have a DB field of type OLE Object. We are storing
bytes of data (blobs).. we are running into the situation
that everytime this field is updated, the DB grows.... I
ran the experiment where I was saving 8,000 bytes to this
field... in a loop of 10,000 times... my database size
grew from 3,500KB to 800,000KB ... and all I did was
iteratively update the same field.... even after doing
a DB commit, the size did not shrink. I did a compact,
and then it shrank back down to around the 3,500KB mark.

This sounds like a MAJOR problem with the field type of
OLE Object ?

anonymous replied to John K. on 2 Jun 2004

just an array of doubles (via Copymemory process to a
byte array)

Tony Toews replied to John K. on 02 Jun 2004

Could be. Do you have all the fixes for MS Access and Jet installed?

Microsoft Access Fixes, Patches and Updates
http://www.granite.ab.ca/access/msfixes.htm

This sounds quite interesting. Do you have a MDB with just this test
code that you can zip and email me? After compacting of course.
<smile>.

I'd like to experiment a bit with the various versions of Access and
Jet.

Tony

Archived message: Blobs in Access (MS Access Database)