Hi, well after going nuts, I have finally fixed the problem..

After working with SQL for so long then moving to Access for this small job I did not realise that Access did not support transaction processing.

So I had

<% @Language = VBScript transaction=required %>

as my first statement in the ASP page

I removed the transaction required part and the page worked fine...

just thought I would let you know....

Regards
MarkusJ