ansaurus

Question

.mdb - Access - database appending # on image file

Answer 1

A:

Hyperlink fields (columns) in Access store the data in the format:

Name of hyperlink#http://example.com#

I generally prefer to use textfields, because it is easy enough to follow a hyperlink on a form, if required, and the field (column) is a lot easier to edit and maintain.

Remou 2009-12-12 21:38:26

Note also that hyperlink fields are actually memo fields under the hood. This makes sense since it's very easy for a URL to exceed 255 characters, so if you're storing the URL in plain old text instead of a hyperlink field, you'll probably want to use a memo field, anyway. You won't gain anything in efficiency, but as @Remou points out, it's much simpler to work with.

David-W-Fenton 2009-12-12 21:57:06

I'm still not getting the image to come out. If you go to http://www.centuryautosd.com/see_autos.asp?autoLable=Cadillac you can see what I mean. How can I get this to show the image? Any ideas would be greatly appreciated.

Drea 2009-12-15 15:58:53

You do not seem to have an image at http://www.centuryautosd.com/images/mock-car.jpg where are your images stored?

Remou 2009-12-15 16:06:41

duh! what a dingle fritz - however, come to find out I needed to write a bit of asp code to get it to come out. I got it done. thanks for the help!

Drea 2009-12-15 21:27:47

You are most welcome :)

Remou 2009-12-15 21:59:54

ansaurus

tags:

views:

answers:

.mdb - Access - database appending # on image file

related questions