database adding #.......# to your files?

Question:

When i linked my images to my Access database, i keet getting a #.............# aroung it?
example: database has ""/myimages/picture.jpg""
I was getting this on the picture  "http://www.mysite.com/myimages/picture.jpg#http://picture.jpg#"

How can i fix it?

Answer:

I looked at the database and the column has the "hyperlink" attribute, this can be changed by viewing it in design view.

that should fix it but it might add #...........# in your field so you'll have to use an update query to fix that!