Database of photos 2

[elziko]

I wanna create a database of road names. Then for each road name I'd like to store a load of photos. I cant see ANY way of doing this so that I can browse through/search a rode name and view all the photos stored under that road name.

At the moment the only way I can see of doing it is by having a database that stores a list of filenames for each road and then to write a program to show the photo at each file location for the selected road.

However if there is a way of doing the whole thing in Access then I'd like to know what it is!

Thanks

elziko

 

[Sensibilium]

Storing images inside Access is unnecessary and very complicated, you best option is nearly what you mentioned in your post.

The way I would do it is as follows:

tblRoads
intRoadID - Unique ID for road
txtRoadName - Name of the road
intNoOfImages - Number of images associated with the road.

Don't even bother with the path to the image if all images are held in one specific folder (the easy way)

Then name each of your images according to the RoadID
EG: Bolling Road - ID 23 - 5 images associated.
First image - road23-1.gif
Second image - road23-2.gif
Third image - road23-3.gif
Fourth image - road23-4.gif
Fifth image - road23-5.gif

Then all you need to do is some simple loops in your ASP code to display each of the associated images.

If you stored your images in Access they would be stored in BINARY format which really complicates matters more than necessary.


ahdkaw
ahdkaw@ots.zzn.com

http://sensibilium.com/

'If anythign can go wrong, it will'

 

[Sensibilium]

Ooops! My response is probably completely useless to you... I thought I was in the ASP forum...

Sorry


ahdkaw
ahdkaw@ots.zzn.com

http://sensibilium.com/

'If anythign can go wrong, it will'

 

[Francescina]

There are three possibilities to store Graphic files in Access:

1.) Inside of OLE-controls (standard) inside the tables
2.) In storing only the path and file names (with VBA)
3.) In storing them inside the tables with a third party wizard

Advantages:
1.) Double-clicking the image starts the graphic software
2.) Cheap solution
3.) No bloating, extremely easy to use, full report functionality, no quantity limitation, export-, zoom-, thumbnail-function.

Disadvantages:
1: one single embedded JPG can take up to 100 MB of space, no export of graphic files, problems in reports, limited number of graphics per record
2: you need to retain long file names such as : "C:\Program files\Myapp\graphics\roads\ArlingtonRoad1.jpg" and your clients need to write them
Files can be deleted, moved, renamed
Difficult to deploy
3. You have to invest money.

If you need more information on point 3, just drop me an E-Mail and I will look for the website where you can find this software.

 

[elziko]

Thanks both of you for your answers, you've given me a few more ideas.

And ahdkaw, dont worry, I dont know ASP but I can still do what your suggesting in VB/AIP cant I?!

elziko

 

[Sensibilium]

Elziko, you're probably right, I don't actually see any reason as to why you couldn't do it the way I suggested using VBA in Access.

ahdkaw
ahdkaw@ots.zzn.com

http://sensibilium.com/

'If anythign can go wrong, it will'