Hi Guys,

I have been working on a new website however when parsing registration I am getting an error, Could someone correct my mistake please?

Here's the Error I am getting:
Microsoft VBScript compilation error '800a0409'

Unterminated string constant

/vb14apps/Register.asp, line 36

sql="INSERT INTO Users (Email,Password,Role)
--------------------------------------------^

Code:
<%
email = ""
password = ""
confirmPassword = ""
ErrorMessage = ""

if request.form <> "" then
  email = Request.Form("email")
  password = Request.Form("password")
  confirmPassword = Request.Form("confirmPassword")

  if email="" or password="" then
    ErrorMessage = "You must specify both email and password."
  end if
  if password <> confirmPassword then
    ErrorMessage = "Password and confirmation do not match."
  end if

  if ErrorMessage = "" then 
    set conn = Server.CreateObject("ADODB.Connection")
    conn.Provider = "Microsoft.Jet.OLEDB.4.0"
DSNtest=dsntest & Server.MapPath("./Users.mdb")
Conn.Open DSNtest
    set rs = Server.CreateObject("ADODB.recordset")
    rs.Open "Select * FROM Users WHERE Email = '" & email & "'", conn
    if rs.EOF = true then
     sql="INSERT INTO Users (Email,Password,Role)
      VALUES ('" & email & "','" & password & "','guest')"
      conn.Execute(sql)
      Response.Redirect("Default.asp")
    else
      ErrorMessage = "Email address is already in use."
    end if
  end if
end if

if ErrorMessage <> "" then
  response.write("<p>" & ErrorMessage & "</p>") 
  response.write("<p>Please correct the errors and try again.</p>") 
end if
%>
If someone can correct my problem I would be very much appreciated!

Thanks!