hi there,

I'm new to programming in ASP and need some assistance. I'm building a small web application to save contact information into an Ms Access database.

Problem scenario:
----------------------

page1.asp is a form to fill in details to be saved into the database. It passes to page2.asp where the ASP codes are.

Sample of the code:
-------------------------

SQL= "INSERT INTO Contact(title, fname) VALUES ('"&cstr(Request.Form("title"))&"','"&cstr(Request.Form("fname"))&"')"

Set rs = Conn.Execute(SQL)

This is the error message i get:
---------------------------------------

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

/page2.asp, line 20

Line 20: Set rs = Conn.Execute(SQL)

Please help! Would appreciate this!!!