|
 |
asp_database_setup thread: Cannot Update. Database or Object is Read-only.
Message #1 by "Mail List Management Account" <lists@m...> on Wed, 02 May 2001 06:54:27 -0400
|
|
To whom it may concern enough....
Below is the code I am using to attempt to update an access database. I
am getting the following message.
"Cannot Update. Database or Object is Read-only."
What's up with this???
Thanks,
Bill S.
<%
rn = request.form("rn")
account = request.form("account")
location = request.form("location")
system = request.form("system")
value = request.form("value")
doc = request.form("doc")
nstep = request.form("nstep")
pserv = request.form("pserv")
prob = request.form("prob")
plan = request.form("plan")
status = request.form("status")
cinfo = request.form("cinfo")
total = request.form("total")
set rsquery = server.createobject("adodb.recordset")
rsquery.open "select * from prospects where index=" & cint(rn),
connection, adopenkeyset, adlockoptimistic
if not rsquery.eof then
username = rsquery("fn")
region = rsquery("region")
mor = rsquery("mor")
yor = rsquery("yor")
myor = mor & ", " & yor
rsquery("account") = account
rsquery("location") = location
rsquery("system") = system
rsquery("value") = value
rsquery("doc") = doc
rsquery("nstep") = nstep
rsquery("pserv") = pserv
rsquery("prob") = prob
rsquery("plan") = plan
rsquery("status") = status
rsquery("cinfo") = cinfo
rsquery("total") = total
rsquery.update
rsquery.close
set rsquery = nothing
connection.close
set connection = nothing
else
rsquery.close
set rsquery = nothing
connection.close
set connection = nothing
response.write "Something has gone wrong. Please email software
technical support."
end if
%>
===================================
Custom Web Application Programming
Contact: was@i...
===================================
Your Message Here
20,000 messages for $39.00
Contact: lists@m...
===================================
Message #2 by ssteward@a... on Wed, 2 May 2001 08:54:10 -0500
|
|
Either your database is read only, your database/recordset object is
readonly, or you don't have write permissions on the file.
Shawn
-----Original Message-----
From: Mail List Management Account [mailto:lists@m...]
Sent: Wednesday, May 02, 2001 5:54 AM
To: ASP Database Setup
Subject: [asp_database_setup] Cannot Update. Database or Object is
Read-only.
To whom it may concern enough....
Below is the code I am using to attempt to update an access database. I
am getting the following message.
"Cannot Update. Database or Object is Read-only."
What's up with this???
Thanks,
Bill S.
<%
rn = request.form("rn")
account = request.form("account")
location = request.form("location")
system = request.form("system")
value = request.form("value")
doc = request.form("doc")
nstep = request.form("nstep")
pserv = request.form("pserv")
prob = request.form("prob")
plan = request.form("plan")
status = request.form("status")
cinfo = request.form("cinfo")
total = request.form("total")
set rsquery = server.createobject("adodb.recordset")
rsquery.open "select * from prospects where index=" & cint(rn),
connection, adopenkeyset, adlockoptimistic
if not rsquery.eof then
username = rsquery("fn")
region = rsquery("region")
mor = rsquery("mor")
yor = rsquery("yor")
myor = mor & ", " & yor
rsquery("account") = account
rsquery("location") = location
rsquery("system") = system
rsquery("value") = value
rsquery("doc") = doc
rsquery("nstep") = nstep
rsquery("pserv") = pserv
rsquery("prob") = prob
rsquery("plan") = plan
rsquery("status") = status
rsquery("cinfo") = cinfo
rsquery("total") = total
rsquery.update
rsquery.close
set rsquery = nothing
connection.close
set connection = nothing
else
rsquery.close
set rsquery = nothing
connection.close
set connection = nothing
response.write "Something has gone wrong. Please email software
technical support."
end if
%>
Message #3 by Craig Flannigan <ckf@k...> on Thu, 03 May 01 09:46:20 BST
|
|
It's probably too obvious, but have you checked the permissions on
the file?
_____________________________________________________
Craig Flannigan
Development Supervisor - Business Systems
Kaye House
Tel: 0114 256 6070
Email: ckf@k...
----------
>To whom it may concern enough....
>
>Below is the code I am using to attempt to update an access
>database. I
>am getting the following message.
>
> "Cannot Update. Database or Object is Read-only."
>
>What's up with this???
>
>Thanks,
>
>Bill S.
>
>
><%
>rn = request.form("rn")
>account = request.form("account")
>location = request.form("location")
>system = request.form("system")
>value = request.form("value")
>doc = request.form("doc")
>nstep = request.form("nstep")
>pserv = request.form("pserv")
>prob = request.form("prob")
>plan = request.form("plan")
>status = request.form("status")
>cinfo = request.form("cinfo")
>total = request.form("total")
>
>set rsquery = server.createobject("adodb.recordset")
>rsquery.open "select * from prospects where index=" & cint(rn),
>connection, adopenkeyset, adlockoptimistic
>
>if not rsquery.eof then
>username = rsquery("fn")
>region = rsquery("region")
>mor = rsquery("mor")
>yor = rsquery("yor")
>myor = mor & ", " & yor
>rsquery("account") = account
>rsquery("location") = location
>rsquery("system") = system
>rsquery("value") = value
>rsquery("doc") = doc
>rsquery("nstep") = nstep
>rsquery("pserv") = pserv
>rsquery("prob") = prob
>rsquery("plan") = plan
>rsquery("status") = status
>rsquery("cinfo") = cinfo
>rsquery("total") = total
>
>rsquery.update
>rsquery.close
>set rsquery = nothing
>connection.close
>set connection = nothing
>else
>rsquery.close
>set rsquery = nothing
>connection.close
>set connection = nothing
>response.write "Something has gone wrong. Please email software
>technical support."
>end if
>%>
|
|
|
View Cart
