images - OLE object or UNC?

[gusset]

i am storing some images "in" an Access database. please could you let me know whether it would be better to store them as OLE objects in the database or to store a relative path to a folder?

i am vba-proficient so would probably choose the flexibility of the latter unless there is a good reason not to.

many thanks

gusset

 

[tdion]

I am no Access expert, but common sense tells you to store the file path. As the database grows larger (and images are especially large) you will find yourself literally waiting for your computer to finish a query.

If you MUST store an image as a BLOB (OLE object) then try to compress it first (either by zipping it or reducing the resolution.) You will then need to uncompress it "on-the-fly" when it is pulled from the DB.

Again, this is only common sense... I don't have years of experience like some of these other people do. -TD

 

[gusset]

yes, common sense leads me to that conclusion. there must be some advantage to using ole objects, though, else MS would not offer it. i forgot about the hyperlink field, by the way.