I copy and paste it directly to browser address bar it works so the address is ok,
Then I have to assume the link is a text field in your table because in Access, such links are wrapped in # as in #www.somewebpage#
It should be a hyperlink field, and your macro/code should be using FollowHyperLink method when clicked on. Plus the form field should be set to hyperlink type in form property sheet.
Some say that hyperlink fields are more trouble than they're worth and that you should just use the follow method on a text field.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.