http://support.microsoft.com/default.aspx?scid=kb;en-us;Q241271&sd=tech
How can I prevent this error occuring. Happens each time I am doing
something with Dreamweaver in relation to the database I have.

Did you read the section marked WORKAROUND?

I suggest that you stop using Dreamweaver to write your code. Lay out your
pages in Dreamweaver if that's what you like to use, but for any ASP'ing,
open the pages up in a text editor (www.textpad.com is my editor of choice)
and code the ASP yourself. This may seem like a bit of a task if you're new
to ASP, but it will be incredibly better to code yourself.

Ray at home

[quoted text, click to view]