Cannot update. Database or object is read-only.

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Cannot update. Database or object is read-only.

Logged in as: Guest

arrSession:exec spGetSession 2,3,116

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> Cannot update. Database or object is read-only.
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Cannot update. Database or object is read-only. - 6/6/2001 4:32:46 AM

pagooda

Posts: 54
Score: 0
Joined: 5/23/2001
From: USA
Status: offline

Microsoft JET Database Engine error '80040e09'

Cannot update. Database or object is read-only.

/addnew.asp, line 9
No sure why I'm receiving this error. I can write the fields to a
page but not update.
Here is my code, line 9 is objrs.addnew
*********************8
Dim objrs, x, strcriteria, strconnect
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=e:\websites\liquiflo\liquiflo.mdb;"
Set objrs = Server.CreateObject ("ADODB.Recordset")
objrs.open "Info", strConnect, 2, 2
objrs.MoveLast
objrs.AddNew
Objrs("Name")=request("Name")
*************************

Post #: 1

Re: Cannot update. Database or object is read-only. - 6/6/2001 4:33:54 AM

pedx

Posts: 16
Score: 0
Joined: 5/22/2001
From: USA
Status: offline

you cannot update because the defaul type for an
ADODB.Recordset is read-only. if you want to make modification
you have to put some suplimentary lines like this:

*********************8
Dim objrs, x, strcriteria, strconnect
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=e:\websites\liquiflo\liquiflo.mdb;"
Set objrs = Server.CreateObject ("ADODB.Recordset")
objrs.CursorType=1 'adOpenKeyset
objrs.LockType=3'adLockOptimistic
objrs.open "Info", strConnect, 2, 2
objrs.MoveLast
objrs.AddNew
Objrs("Name")=request("Name")
*************************

this will surely help,

(in reply to pagooda)

Post #: 2

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.

All Forums >> [Scripting] >> ASP >> Cannot update. Database or object is read-only.

Page: [1]

Jump to:

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts