storing images in databases

[antonyx]

i am about to create a simple database for an estate agency..

they would like to have one image per record of the property (from the outside)

and 3 or 4 images per record of the property (interior shots)

how can you store images/multiple images in access for a particular record..im sure it has something to do with the ole object

 

[reclusivemonkey]

You need to create a seperate table for the interior shots, and then reference this table to the Primary Key or your properties table.

 

[ssteinke]

It is almost always recommended NOT to store the image as an OLE, but rather to store just the path name, i.e. "C:\Program Files\ProgramName\Pics", and keep the actual pics in that location.

This may help a bit, but do a search for storing images and you will find several threads about this topic.

 

[ScottGem]

I agree with ssteinke. The method in the indicated in the article he links to is the preferred one. You can use the same method if an unbound image control on forms as well as report. For a Form you use the On Current event to set the imagepath.

In your case, since you want to store multiple images I would use a subtable like:

tblImages
ImageID (PK autonumber)
ImagePath
ImageDescription
PropertyID (FK)

You can then use a subform to display as many images as you need.

 

[antonyx]

ok.. well if you lot just take a look at this..

http://forums.aspfree.com/asp-devel...tabase-and-images-with-asp-website-94442.html

if you have time.. the database will simply be the backend of an asp website..
the last few posts in this article outline what i really need from this scenario