| | |
cant save to database
Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Jun 2005
Posts: 8
Reputation:
Solved Threads: 0
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
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
•
•
Join Date: Jun 2005
Posts: 107
Reputation:
Solved Threads: 3
It could sound like you need to put
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)
RS_something.CursorType = 2 RS_something.LockType = 3
Another way is (instead of the "AddNew" and "Update" methods)
strSQL = "INSERT INTO table_name VALUES ('" & Request.Form("name") & "', '" & .....
ConnectionObject.Execute strSQL![]() |
Similar Threads
- insert and update data in two different database (JSP)
- I want to save in an access database (C)
- Sorting Database Results (PHP)
- Unsure how to save to database dynamic Textfield values (JSP)
- Gallery database (MS SQL)
- Assistance needed with graphics to be used in database. (Visual Basic 4 / 5 / 6)
Other Threads in the ASP Forum
- Previous Thread: Assigning values to variables
- Next Thread: retrieving ids from dynamically created controls in asp.net
Views: 2946 | Replies: 1
| Thread Tools | Search this Thread |
Tag cloud for ASP
archive asp asp.net aspandmssqlserver2005 aspandmssqlserver2005connection aspconnection calendar changeable connection current database databaseconnection diagnostics dreamweaver excel fso html iis microsoft msmsql mssql2005 mssqlserver2005 mssqlserver2005andasp mssqlserverandasp opentextfile query record searchbox selectoption server single specfic sqlserver sqlserverconnection toolkit update web webserver windows7





