Storing Images In Access - Best Approach

[meyvn77]

Hello -
I am looking for the best way to store images in a Access DB.
My Idea -
I have a table with 150,000 records. These recoreds represent a Crash
(Traffic Accident).
I have 50 different images that represent almost any type of Accident.
Each crash record can be represented by one of those 50 images
(depending on the Crash Data).

I don't want to waste space by having each record have a BLOB field w/
the image in it.
I was thinking of having 2 tables one with a ID, and the image (50
records) and one with the 150,000 crash records. Then I want to link
the tables by ID and be able to plot the images on a VB form in VB
using ADO. I do not want to store the path of the image in the DB and
have the image outside the DB.
Do yall think I will be able to do this in this manner? If not any
altenatives would be very helpful.

Thanks,
Chuck

 

[Br@dley]

Hello -
I am looking for the best way to store images in a Access DB.
My Idea -
I have a table with 150,000 records. These recoreds represent a Crash
(Traffic Accident).
I have 50 different images that represent almost any type of Accident.
Each crash record can be represented by one of those 50 images
(depending on the Crash Data).

I don't want to waste space by having each record have a BLOB field w/
the image in it.
I was thinking of having 2 tables one with a ID, and the image (50
records) and one with the 150,000 crash records. Then I want to link
the tables by ID and be able to plot the images on a VB form in VB
using ADO. I do not want to store the path of the image in the DB and
have the image outside the DB.
Do yall think I will be able to do this in this manner? If not any
altenatives would be very helpful.

Thanks,
Chuck

I always keep the images external to my db. I just find it easier and my
db doesn't bloat. Given you don't want to store the images externally I
don't see many other good alternatives. If you want to store the images
in a table then yes, good db design would dictate that they should be
stored in a seperate table with an ID that you then use to link to
multiple records in your accident table.
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response