PDA

View Full Version : Incorporate images into database



Chemical Ali
21-11-2005, 11:19 AM
I have created an access database table for my DVD collection and was wanting to add a field to include a thumbnail or mini-image of the cover.
Does anyone know how to do this?

Thanks in advance

Rob99
21-11-2005, 11:22 AM
The database cannot hold the image itself, just the location, either on your local computer or on the net.

So you would just use plain text

maccrazy
21-11-2005, 05:14 PM
Databases can hold images (well SQL based ones can) but it is better to store a link to the image though.

somebody
21-11-2005, 05:58 PM
I've accidentally stored images in a MS Access database before - I think it was using an "OLE Embedded object" or something along those lines - can't remember exactly how I did it.

Rob99
22-11-2005, 12:03 AM
Databases can hold images (well SQL based ones can) but it is better to store a link to the image though.Interesting, do you have a link/info.

Rob99
22-11-2005, 12:11 AM
Never mind found it, although I would say the size of the database would go through the roof if lots of images were stored.

http://dev.mysql.com/doc/refman/5.0/en/blob.html

andrew93
22-11-2005, 08:15 AM
Useful information here. (http://office.microsoft.com/en-us/assistance/HP052802251033.aspx)