Oh sorry,
Something like this should work
On Error Resume Next
....
your db statement
Select Case Err.Number
Case.....
Response.Redirect somewhere else
End Select
I bet there are lots of examples on ASP sites. Might be worth a try.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]