FollowHyperlink - Tearing My Hair Out

[Steve25]

Hi,

I've got a problem with a piece of code.

The code in access (2010) follows a hyperlink:

Application.FollowHyperlink url

The hyperlink is an asp page which collates orders. If I copy the hyperlink into a browser it works fine, but if access does it then the asp file doesn't work.

It seems to be centred around this code on the asp page:

dbc.Execute("UPDATE orders SET downed = 1 WHERE orderid = " & theorderid)
dbc.Execute("UPDATE orders SET oprocessed = 1 WHERE orderid = " & theorderid)

If I don't include the "downed" bit it works fine but with both it doesn't work, unless I copy the address straight into a browser.

Any ideas?

Thanks
Steve
:banghead: