Beginner in ASP - query error

[jleesc]

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!!!

[bolti]

This is not a error you get becouse your syntax is wrong


This is simply a security thing in Win XP, I think its there atleast.


You will have to go to the directory where you store your Database and go to security.

There you have a user called either domain user, web user or just simply user.

You have to allow him to modify that directory.


If you have the simple file sharing on in XP you will have to turn that of to change this.

You do that by going to folder options in the control panel and there you uncheck the "Using Simple File Sharing(Recomended)" checkbox...


Hope this will help you