ole objects

[cdacey]

Hi,
I have a table in my database that has an ole object field. Typically we use the insert object routine to import or link an image to that field in the record. An example of this is an employee photo field (ole object type) in an employee record table. My problem is that when I insert an object, say a .bmp file that is 45kb in size, the database size increases by 5 mb. This pretty much happens regardless of whether I choose "link" or not during the insert object routine.
Can anyone explain this ? Is there a setting somewhere to control the size of this field?
Thanks
Chris

 

[neileg]

This is a well known problem with Access. You need to avoid holding images in your data. You need to use a way of linking to an image that is stored outside the database. You could use a hyperlink, or there are other options. Search these forums for methods.

 

[cdacey]

Thanks
At least I'm not going crazy
I have searced and actually found an example of what you saying.
Thanks for responding
Chris