Hey Shabbir, great code!!
I implemented it to check a MS Access field for an email address. The problem is I set it up so that if a user accidentally types in the wrong address, they are re-directed to a page that allows them to re-enter the address again. If they re-enter the correct Email from that page, they get this message: “ADODB.Recordset error '800a0e78' Operation is not allowed when the object is closed”.
I looked into the problem and I believe it is a syntax issue, ref: http://databases.aspfaq.com/database...look-like.html
Thanks so much!