cant save to database

Reply

Join Date: Jun 2005
Posts: 8
Reputation: Wiz-kid is an unknown quantity at this point 
Solved Threads: 0
Wiz-kid Wiz-kid is offline Offline
Newbie Poster

cant save to database

 
0
  #1
Jun 24th, 2005
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
Reply With Quote Quick reply to this message  
Join Date: Jun 2005
Posts: 107
Reputation: madmital is an unknown quantity at this point 
Solved Threads: 3
madmital madmital is offline Offline
Junior Poster

Re: cant save to database

 
0
  #2
Jun 24th, 2005
It could sound like you need to put
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)
strSQL = "INSERT INTO table_name VALUES ('" & Request.Form("name") & "', '" & .....
ConnectionObject.Execute strSQL
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:




Views: 2946 | Replies: 1
Thread Tools Search this Thread



Tag cloud for ASP
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC