Hello everyone,
I am running into a slight problem with my database design. Currently, I am constructing a database that acts as an inventory system. For the inventory table, I have one column with its data type set as an OLE Object for the purpose of adding an image of each product into the table. To insert the image, I have a form linking to the table with an OLE Object box and its property is set to only allow linked images. Now my question is, why would that column be adding 230 mb to my database size if all of the images are linked and not embedded? There are only about 85 entries into the table. Also, I have tried compacting and repairing and that has not been able to fix the problem. Any ideas? Thanks in advance!
Jason