Anyone know how to link a image map to a Access database?

I'm working on a project in which I'd like to show a neighborhood map (platte map), which of course would be the image map. Then when an individual lot/home site is selected/clicked on the image map it would open the corresponding record in the database. Of course in the database I could go nuts with photos of the house, photos and details of the participating families, etc.

This project does NOT need to be on the net, so I'm really not talking about a dynamic website. At the most it would be nice to distribute the thing on CD, or just share the file.

Also, it doesn't have to be Access (that's just what I'm dumping data into), the real trick is just to link the imagemap to a database record.

Anyone done this?

 

can the page refresh after the click or do want to do it without a browser refresh?

 

Hmmm, to refresh....or not?

Really doesn't matter, whatever works. Again, I'm really not looking to use it on a server (internet), so it really doesn't even have to use a broswer.

Thanks for the reply & cheers to you -

 

If you only want 1 picture per record then you could just make a field called "PICTURE" and make its datatype a hyperlink and then link to the picture file you have.

If you have multiple pics you might want to create a seperate table of just picture links and have a ID field on picture table that correspondes to the ID field of the data table.

 

Hmm, that might work. There is only on photo in the record but I'd like to see all the other data fields for that record too (address, phone number, etc).

Ideally, a click on the image map would open the entire corresponding record.

 

What development language are you working in? Straight HTML? ASP? .NET? php? cgi?

 

[QUOTE]Originally posted by thunderchicken
[B]What development language are you working in?

 

create a table of the geometric areas of the image map and relate those areas to the record ID of the corresponding house. Postgres has built in geometric data types, that might be useful.

Then when someone clicks, build your sql to join the area table against the house info table based on the coordinates you from the map click.

 

on the cd, you can include the database, webserver and everything and put a little batch file wrapper around it all. ppl throw in the cd, it starts the database and the webserver and opens a browser to point to the new localhost webserver. very easy, and then it's also a standard interface so should be easier for users to use right away. I'd say that's easier than a standalone app w/ access db.

 

Thanks Josh -