I am inserting an image of 34k and my Dbase increase of 10MB, Why?

[IEF]

I do not how to do, but I have a form where is a object window in where the
user can insert an image (bmp or jpg).

The problem is: when the user insert a small image of 50 kb, the dbase size
increases of 10 MB. Why? I don't know why it is happening?

 

[Wayne Morgan]

See if the information that Tony has here will help. There are several links
on this page to follow for more information.

http://www.granite.ab.ca/access/imagehandling.htm

 

[Joseph Meehan]

I do not how to do, but I have a form where is a object window in where
the
user can insert an image (bmp or jpg).

The problem is: when the user insert a small image of 50 kb, the dbase
size
increases of 10 MB. Why? I don't know why it is happening?

The short answer is it is creating room for images in all the records.

Try using a link to the image rather than the image.

Keep in mind you will need to do a compact to recover the size.

 

[Stephen Lebans]

Joseph even when linked the OLE object will contain a full size
uncompressed Bitmap of the original image. I'd guess that the OP will
see a reduction of 50% at best.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.