Image problem

[Annemarie]

Hello!

I am inserting images into a table...and keep getting an error. I have
reinstalled photo editor to allow JPEG images. All of the sudden I am
receiving an error message "Invalid Argument." and can no longer enter
anything or change anything.

Please help!

 

[bob]

This sounds like one of the symptoms of hitting the database size limit – is the mdb file anywhere near
2GB?

Using Photo Editor to store JPEGs causes a huge overhead, since it stores each image uncompressed, then
adds up to 2 more uncompressed copies for good measure. This can cause the file to grow by as much as
200 *times* the size of the image files you add to the database, so you can reach the 2GB size limit very
quickly.

Either store the images externally as files, or as blobs if you want them in the database.

 

[Annemarie]

This sounds great...but I can't figure out how to do it. I have looked
through the download info from a few posts back...but am totally lost.
I tried to attach externally as file...but in the report the filename
just shows up not the picture. Any suggestions to help?