|
 |
asp_database_setup thread: Access read-only error
Message #1 by Hussain Bahrainwala <bahrainwala@y...> on Mon, 14 May 2001 00:37:06 -0700 (PDT)
|
|
i have created a site which uses the access file,
which is kept in the same directory with the other
.asp files, while retreiving the data, it works very
fine on the net, but when i try to insert,update or
delete records from any tables, it shows an error
Microsoft JET Database Engine error '80040e09'
Cannot update. Database or object is read-only.
pls help me out
Message #2 by "Pappas Nikos" <pappas@c...> on Mon, 14 May 2001 12:46:50 +0300
|
|
Looks like permissions for the folder that contains the database
are not set properly
or your connection string does not use the right cursor,locktype.
there's a piece of code I use successfully try it out.
...................
set myConnection = Server.CreateObject("ADODB.Connection")
set rsTitleList = Server.CreateObject("ADODB.Recordset")
myConnection.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=" & Server.Mappath("../data/Sales.mdb")& ";" ,IUSR,""
MyID= request.Form("ID")
SqlString = "SELECT * FROM products WHERE ID = " & MyID
rsTitleList.open SqlString ,myConnection,3,3
...................etc
I hope it helps
check Ken's site for connections and problems , really helped me a lot.
http://www.adopenstatic.com/faq/
Regards Nikos
-----Original Message-----
From: Hussain Bahrainwala [mailto:bahrainwala@y...]
Sent: Monday, May 14, 2001 12:39 PM
To: ASP Database Setup
Subject: [asp_database_setup] Access read-only error
i have created a site which uses the access file,
which is kept in the same directory with the other
.asp files, while retreiving the data, it works very
fine on the net, but when i try to insert,update or
delete records from any tables, it shows an error
Microsoft JET Database Engine error '80040e09'
Cannot update. Database or object is read-only.
pls help me out
Message #3 by "Cole, R. MR DOIM" <8r8251@e...> on Mon, 14 May 2001 08:13:13 -0400
|
|
See KB article Q253580 for help with Access and ASP
Rich Cole
Signal Corporation
-----Original Message-----
From: Hussain Bahrainwala [mailto:bahrainwala@y...]
Sent: Monday, May 14, 2001 5:39 AM
To: ASP Database Setup
Subject: [asp_database_setup] Access read-only error
i have created a site which uses the access file,
which is kept in the same directory with the other
.asp files, while retreiving the data, it works very
fine on the net, but when i try to insert,update or
delete records from any tables, it shows an error
Microsoft JET Database Engine error '80040e09'
Cannot update. Database or object is read-only.
pls help me out
|
|
|
View Cart
