I've got about 200 pictures on a server. I want people to be able to find the picture they want by keyword. Do I need some sort of database, application, sql, could it be done in Access some how? I'm a bit lost on this one...

Casp

_________________

If you store data about the image in a database table together with it's filename you could query the table and then use the filename in a string to retrieve and display the the pic.

probably the easiest way both from being able to find examples and also maintaining the data.

however you could also use XML to store the same thing.

is this a windows or web application ?

http://www.aspphotogallery.com/ would do it and only costs £10-£20 (ish)

...and if you search there's tons of other examples (Haven't searched too hard but I'm sure there's a shiney flash application which does this).

If it didn't need to be particulalry private you could even get all Web 2.0 about it and use Flickr and make your own folder/area

for a windows solution it may also be possible to use picasa which is very slick and includes an import from folder option which could be a network share

<edit>
in fact I'd recommend Picasa using a mapped drive to the photo folder - just tried it and might be using that here - thanks for the inspiration !

File > Add Folder to Picasa
pick mapped drive to photo library - ta da !