cant save to database

Expand Post »

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

Similar Threads

insert and update data in two different database in JSP
I want to save in an access database in C
Sorting Database Results in PHP
Unsure how to save to database dynamic Textfield values in JSP
Gallery database in MS SQL

Wiz-kid

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

8 posts
since Jun 2005

Permalink

Jun 24th, 2005

Re: cant save to database

It could sound like you need to put

(Toggle Plain Text)

RS_something.CursorType = 2
RS_something.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)

(Toggle Plain Text)

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

madmital

Reputation Points: 10

Solved Threads: 5

Junior Poster

Offline

119 posts
since Jun 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP Forum Timeline: Assigning values to variables

Next Thread in ASP Forum Timeline: retrieving ids from dynamically created controls in asp.net

DaniWeb Message

Cancel Changes

User Name
Password