Hello. I get the folowing error when I use an insert statement on an Access 2000 database:

Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/BIS355/pgEmpAddII.asp, line 27

I'm using the following vbScript:

<% Dim varCn, varSQL, varCnString, varRs %>

<%
    Set varCn = Server.CreateObject("ADODB.Connection")
    varCnString ="Provider=Microsoft.Jet.OLEDB.4.0;" & _
                  "Data Source=" & Server.MapPath("\bis355\dbEmployees.mdb") &";" & _
                  "Persist Security Info=False"


    varCn.ConnectionString = varCnString
    varCn.Open(varCnString)

    var1 =Request.Form("wtxtFirstName")
    var2 = Request.Form("wtxtLastName")
    var3 = Request.Form("wtxtEMailName")
    varSQL = "INSERT INTO tblEmployees(tblEmployees.fldFirstName, tblEmployees.fldLastName, tblEmployees.fldEmail) values ('" & var1 & "', '" & var2 & "', '" & var3 & "')"

    'set varRS=server.CreateObject("ADODB.Recordset")
    'Set varRS.ActiveConnection = varCn

    varCn.Execute varSQL
    varCn.Close
    varCn = nothing
%>

If anyone can help, I'd appreciate it! Thanks!

http://p2p.wrox.com/topic.asp?TOPIC_ID=136

...but the Soon is eclipsed by the Moon