How to fix "operation must be an updateable query" error?

[Nitish Muley]

Whenever I execute the following ASP code in IIS environment, I get the error as- "operation must be an updateable query"
Following is a simple ASP code for insertion of record retrieved from querystring into database

<%
dim conn,rs,name,address,sql
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
set rs=Server.CreateObject("ADODB.Recordset")
 
name=Request.QueryString("entry_name")
address=Request.QueryString("entry_address")
 
sql="INSERT INTO Table(name,address) values('"&name&"','"&address&")"
conn.Execute sql
%>

I get this type of error for the underlined command.
Please anybody specify me a solution.

[Rabbit]

Table is a reserved name, and so is Name, did you really name your table table and your field name?

[Nitish Muley]

I named Table table in which there are two fields viz. name and address

[Rabbit]

That's probably why then. Either rename them or qualify them.

[jhardman]

There also appears to be a missing single quote (') before the last parenthesis