Member Avatar for Wiz-kid

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

  • 2 Contributors
  • 1 Reply
  • 90 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by madmital
Member Avatar for madmital

It could sound like you need to put

[I]RS_something[/I].CursorType = 2
[I]RS_something[/I].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") & "', '" & .....
[I]ConnectionObject[/I].Execute strSQL
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.