cant save to database

Hi all
I have created an Access database and I can retrive info from it, but when I try to upload new info using a form I created it gives me an error which says "Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
/adding.asp, line 36". and sometimes it sometimes cant regognise my .updata, it looks like it only allow to uodate on the database but not from the form.

Please help... :o

Wiz-kid

Newbie Poster

8 posts since Jun 2005

Reputation Points: 10

Solved Threads: 0

6 Years Ago

It could sound like you need to put

<em>RS_something</em>.CursorType = 2
<em>RS_something</em>.LockType = 3

in your code before opening the recordset, but I can't be sure since you don't post any code.

Another way is (instead of the "AddNew" and "Update" methods)

strSQL = "INSERT INTO table_name VALUES ('" & Request.Form("name") & "', '" & .....
<em>ConnectionObject</em>.Execute strSQL

madmital

Junior Poster

120 posts since Jun 2005

Reputation Points: 10

Solved Threads: 5

This article has been dead for over three months

You