By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,712 Members | 1,271 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,712 IT Pros & Developers. It's quick & easy.

problem running code...

P: n/a
Hi!

I have a problem running my code on 2000 server and iis5.0.

The code runs perfectly on my localhost (xp iis5.1) but when i run it on
2000 server iis5.0 I get this error:

--------------------------------------

operation must use an updateable query

execute_insert_text_content.asp l 83
--------------------------------------

My code looks like this:
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''

<%@ LANGUAGE=JScript %>
<% Session.LCID = 1044 %>
<OBJECT id=cn PROGID="ADODB.Connection" RUNAT="server"></OBJECT>
<OBJECT id=rst PROGID="ADODB.Recordset" RUNAT="server"></OBJECT>
<OBJECT id=cm PROGID="ADODB.Command" RUNAT="server"></OBJECT>

<!--#include file="./library/utils.inc"-->
<!--#include file="./library/adojavas.inc"-->
<!--#include file="./library/db.inc"-->

<%
Response.Buffer = true;

CheckUser(Application("UserLevel"));

var sSQL = "";

var iNodeId = FormGetInteger("iNodeId", -1);
var iLanguageId = FormGetInteger("oComboLanguageId", -1);
var iListId = FormGetInteger("iListId", -1);
var strContentTitle = Request.Form("oEditContentTitle").Count > 0
? Request.Form("oEditContentTitle").Item(1) : "";
var strContentSubTitle = Request.Form("oEditContentSubTitle").Count
0 ? Request.Form("oEditContentSubTitle").Item(1) : ""; var strContentImage1 = Request.Form("oEditContentImage1").Count >
0 ? Request.Form("oEditContentImage1").Item(1) : "";
var strContentImage2 = Request.Form("oEditContentImage2").Count >
0 ? Request.Form("oEditContentImage2").Item(1) : "";
var strDocumentLink = Request.Form("oEditDocumentLink").Count > 0
? Request.Form("oEditDocumentLink").Item(1) : "";
var strDocumentLinkDescription =
Request.Form("oEditDocumentLinkDescription").Count > 0 ?
Request.Form("oEditDocumentLinkDescription").Item( 1) : "";
var strContentBody = Request.Form("oTextAreaContentBody").Count 0 ? Request.Form("oTextAreaContentBody").Item(1) : "";

var bMoreContents = FormGetInteger("iMoreContents", 0) == 1 ?
true : false;
var Fil1 = Request.Form("Fil1").Count > 0 ?
Request.Form("Fil1").Item(1) : "";
var Fil2 = Request.Form("Fil2").Count > 0 ?
Request.Form("Fil2").Item(1) : "";
var Fil3 = Request.Form("Fil3").Count > 0 ?
Request.Form("Fil3").Item(1) : "";
var Fil4 = Request.Form("Fil4").Count > 0 ?
Request.Form("Fil4").Item(1) : "";

if((iNodeId == -1) || (iLanguageId == -1) || (iListId == -1))
Response.Redirect("./tree_cms.asp");

cn.Open(Application("ADOConnectionString"));

cm.ActiveConnection = cn;

sSQL = "SELECT content_id FROM Content_Text WHERE topic_id=" + iNodeId;
sSQL += " AND language_id=" + iLanguageId + " AND list_id=" + iListId + "
AND preview=0";

rst.Open(sSQL, cn);

if(!rst.EOF)
{
// Update
cm.CommandText = "UPDATE Content_Text SET title = ?, sub_title = ?, body =
?, picture_file_name_1 = ?, ";
cm.CommandText += "picture_file_name_2 = ?, Fil1 = ?, Fil2 = ?, Fil3 = ?,
Fil4 = ?, document_link = ?, document_link_description = ?,";
cm.CommandText += "modification_date = " + GetActualDbDate() + ", user_name
= ? WHERE content_id=?";
cm.Parameters.Append(cm.CreateParameter("title", adVarChar, adParamInput,
255));
cm.Parameters.Append(cm.CreateParameter("sub_title ", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("body", adLongVarWChar,
adParamInput, 20480000));
cm.Parameters.Append(cm.CreateParameter("picture_f ile_name_1", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("picture_f ile_name_2", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("Fil1", adVarChar, adParamInput,
255));
cm.Parameters.Append(cm.CreateParameter("Fil2", adVarChar, adParamInput,
255));
cm.Parameters.Append(cm.CreateParameter("Fil3", adVarChar, adParamInput,
255));
cm.Parameters.Append(cm.CreateParameter("Fil4", adVarChar, adParamInput,
255));
cm.Parameters.Append(cm.CreateParameter("document_ link", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("document_ link_description",
adVarChar, adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("user_name ", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("content_i d", adInteger,
adParamInput));
cm("title") = CutString(strContentTitle, 255);
cm("sub_title") = CutString(strContentSubTitle, 255);
cm("body") = strContentBody;
cm("picture_file_name_1") = CutString(strContentImage1, 255);
cm("picture_file_name_2") = CutString(strContentImage2, 255);
cm("Fil1") = CutString(Fil1, 255);
cm("Fil2") = CutString(Fil2, 255);
cm("Fil3") = CutString(Fil3, 255);
cm("Fil4") = CutString(Fil4, 255);
cm("document_link") = CutString(strDocumentLink, 255);
cm("document_link_description") = CutString(strDocumentLinkDescription,
255);
cm("user_name") = Session("UserName");
cm("content_id") = rst("content_id").value;
83 cm.Execute();
}
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''
line 83: cm.Execute();

Why does i work on my xp, but not on the 2000 server??????

I have also uploaded my code to another server, and it worked perfectly
there also..

Is there maby some options in iis that are set wrong???
Thanks!

Christopher Brandsdal

Jul 19 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
This is an NTFS permissions problem. Give the IUSR_<machinename> account (or
whatever user context you are using) Read/Write permissions to the folder
(and files) where the .mdb file is, and also to the Windows temp directory.

Cheers
Ken
"Christopher Brandsdal" <ch***********@c2i.net> wrote in message
news:%2***************@TK2MSFTNGP10.phx.gbl...
: Hi!
:
: I have a problem running my code on 2000 server and iis5.0.
:
: The code runs perfectly on my localhost (xp iis5.1) but when i run it on
: 2000 server iis5.0 I get this error:
:
: --------------------------------------
:
: operation must use an updateable query
:
: execute_insert_text_content.asp l 83
: --------------------------------------
:
: My code looks like this:
:
<snip>
Jul 19 '05 #2

P: n/a
hmm.. I have done this...
But it still won't work!
I think something else must be the problem..

"Ken Schaefer" <ke*******@THISadOpenStatic.com> skrev i melding
news:Op**************@TK2MSFTNGP09.phx.gbl...
This is an NTFS permissions problem. Give the IUSR_<machinename> account (or whatever user context you are using) Read/Write permissions to the folder
(and files) where the .mdb file is, and also to the Windows temp directory.
Cheers
Ken
"Christopher Brandsdal" <ch***********@c2i.net> wrote in message
news:%2***************@TK2MSFTNGP10.phx.gbl...
: Hi!
:
: I have a problem running my code on 2000 server and iis5.0.
:
: The code runs perfectly on my localhost (xp iis5.1) but when i run it on
: 2000 server iis5.0 I get this error:
:
: --------------------------------------
:
: operation must use an updateable query
:
: execute_insert_text_content.asp l 83
: --------------------------------------
:
: My code looks like this:
:
<snip>

Jul 19 '05 #3

P: n/a
Assuming this is an Access database (why wouldn't you think this information
was relevant? Always tell us the type and version of database you are using
when asking a database-related question - we are not looking over your
shoulder <grin>) I agree with Ken that this is a permissions issue. See
these articles:
http://www.aspfaq.com/show.asp?id=2062 - updatable cursor
http://www.aspfaq.com/show.asp?id=2009 - 80004005 errors

Depending on where this query is being run (in a regular page, or in the
session_onend event in global.asa), you need to give folder-level Change
permissions to both the IUSR and IWAM accounts for the folder containing the
database. Do not assume these accounts are in the Everyone group (they're
not).

Also, if the database is on a remote machine, the account used to access
that database must be a domain-level account:
http://support.microsoft.com/default...b;EN-US;253580
Finally, there is a slight possibility that the query itself is at fault, so
you should response.write the CommandText and see if it's a runnable query.

HTH,
Bob Barrows
Christopher Brandsdal wrote:
Hi!

I have a problem running my code on 2000 server and iis5.0.

The code runs perfectly on my localhost (xp iis5.1) but when i run it
on 2000 server iis5.0 I get this error:

--------------------------------------

operation must use an updateable query

execute_insert_text_content.asp l 83
--------------------------------------

My code looks like this:
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''

<%@ LANGUAGE=JScript %>
<% Session.LCID = 1044 %>
<OBJECT id=cn PROGID="ADODB.Connection" RUNAT="server"></OBJECT>
<OBJECT id=rst PROGID="ADODB.Recordset" RUNAT="server"></OBJECT>
<OBJECT id=cm PROGID="ADODB.Command" RUNAT="server"></OBJECT>

<!--#include file="./library/utils.inc"-->
<!--#include file="./library/adojavas.inc"-->
<!--#include file="./library/db.inc"-->

<%
Response.Buffer = true;

CheckUser(Application("UserLevel"));

var sSQL = "";

var iNodeId = FormGetInteger("iNodeId", -1);
var iLanguageId = FormGetInteger("oComboLanguageId",
-1); var iListId = FormGetInteger("iListId", -1);
var strContentTitle =
Request.Form("oEditContentTitle").Count > 0 ?
Request.Form("oEditContentTitle").Item(1) : "";
var strContentSubTitle =
Request.Form("oEditContentSubTitle").Count
0 ? Request.Form("oEditContentSubTitle").Item(1) : "";

var strContentImage1 =
Request.Form("oEditContentImage1").Count > 0 ?
Request.Form("oEditContentImage1").Item(1) : "";
var strContentImage2 =
Request.Form("oEditContentImage2").Count > 0 ?
Request.Form("oEditContentImage2").Item(1) : "";
var strDocumentLink =
Request.Form("oEditDocumentLink").Count > 0 ?
Request.Form("oEditDocumentLink").Item(1) : "";
var strDocumentLinkDescription =
Request.Form("oEditDocumentLinkDescription").Count > 0 ?
Request.Form("oEditDocumentLinkDescription").Item( 1) : "";
var strContentBody =
Request.Form("oTextAreaContentBody").Count
0 ? Request.Form("oTextAreaContentBody").Item(1) : "";

var bMoreContents = FormGetInteger("iMoreContents", 0)
== 1 ? true : false;
var Fil1 = Request.Form("Fil1").Count > 0 ?
Request.Form("Fil1").Item(1) : "";
var Fil2 = Request.Form("Fil2").Count > 0 ?
Request.Form("Fil2").Item(1) : "";
var Fil3 = Request.Form("Fil3").Count > 0 ?
Request.Form("Fil3").Item(1) : "";
var Fil4 = Request.Form("Fil4").Count > 0 ?
Request.Form("Fil4").Item(1) : "";

if((iNodeId == -1) || (iLanguageId == -1) || (iListId == -1))
Response.Redirect("./tree_cms.asp");

cn.Open(Application("ADOConnectionString"));

cm.ActiveConnection = cn;

sSQL = "SELECT content_id FROM Content_Text WHERE topic_id=" +
iNodeId; sSQL += " AND language_id=" + iLanguageId + " AND list_id="
+ iListId + " AND preview=0";

rst.Open(sSQL, cn);

if(!rst.EOF)
{
// Update
cm.CommandText = "UPDATE Content_Text SET title = ?, sub_title = ?,
body = ?, picture_file_name_1 = ?, ";
cm.CommandText += "picture_file_name_2 = ?, Fil1 = ?, Fil2 = ?, Fil3
= ?, Fil4 = ?, document_link = ?, document_link_description = ?,";
cm.CommandText += "modification_date = " + GetActualDbDate() + ",
user_name = ? WHERE content_id=?";
cm.Parameters.Append(cm.CreateParameter("title", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("sub_title ", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("body", adLongVarWChar,
adParamInput, 20480000));
cm.Parameters.Append(cm.CreateParameter("picture_f ile_name_1",
adVarChar, adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("picture_f ile_name_2",
adVarChar, adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("Fil1", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("Fil2", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("Fil3", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("Fil4", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("document_ link", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("document_ link_description",
adVarChar, adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("user_name ", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("content_i d", adInteger,
adParamInput));
cm("title") = CutString(strContentTitle, 255);
cm("sub_title") = CutString(strContentSubTitle, 255);
cm("body") = strContentBody;
cm("picture_file_name_1") = CutString(strContentImage1, 255);
cm("picture_file_name_2") = CutString(strContentImage2, 255);
cm("Fil1") = CutString(Fil1, 255);
cm("Fil2") = CutString(Fil2, 255);
cm("Fil3") = CutString(Fil3, 255);
cm("Fil4") = CutString(Fil4, 255);
cm("document_link") = CutString(strDocumentLink, 255);
cm("document_link_description") =
CutString(strDocumentLinkDescription, 255);
cm("user_name") = Session("UserName");
cm("content_id") = rst("content_id").value;
83 cm.Execute();
}
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''
line 83: cm.Execute();

Why does i work on my xp, but not on the 2000 server??????

I have also uploaded my code to another server, and it worked
perfectly there also..

Is there maby some options in iis that are set wrong???
Thanks!

Christopher Brandsdal


Jul 19 '05 #4

P: n/a
Check the permissions again!

If IUSR_<machinename> has Read/Write (RXW) then Creator/Owner needs Full
Control.
Otherwise, if you are have remove the special CreatorOwner user, then
IUSR_<machinename> needs Change (RWXD) permissions.

This is because Access needs to create the .ldb lockfile, which is created
in the same folder as the .mdb file. And it needs to delete it later on. So,
either IUSR_<machinename> needs Change (RWXD) or, since it is the Owner of
the .ldb lockfile, Creator/Owner needs Change (by default, I think C/O has
Full Control).

Cheers
Ken

"Christopher Brandsdal" <ch***********@c2i.net> wrote in message
news:Oc**************@TK2MSFTNGP12.phx.gbl...
: hmm.. I have done this...
: But it still won't work!
: I think something else must be the problem..
:
: "Ken Schaefer" <ke*******@THISadOpenStatic.com> skrev i melding
: news:Op**************@TK2MSFTNGP09.phx.gbl...
: > This is an NTFS permissions problem. Give the IUSR_<machinename> account
: (or
: > whatever user context you are using) Read/Write permissions to the
folder
: > (and files) where the .mdb file is, and also to the Windows temp
: directory.
: >
: > Cheers
: > Ken
: >
: >
: > "Christopher Brandsdal" <ch***********@c2i.net> wrote in message
: > news:%2***************@TK2MSFTNGP10.phx.gbl...
: > : Hi!
: > :
: > : I have a problem running my code on 2000 server and iis5.0.
: > :
: > : The code runs perfectly on my localhost (xp iis5.1) but when i run it
on
: > : 2000 server iis5.0 I get this error:
: > :
: > : --------------------------------------
: > :
: > : operation must use an updateable query
: > :
: > : execute_insert_text_content.asp l 83
: > : --------------------------------------
: > :
: > : My code looks like this:
: > :
: > <snip>
: >
: >
:
:
Jul 19 '05 #5

P: n/a
also check microsoft.com website
there is a known issue with read-rights on a specific key in the registry
"Bob Barrows" <re*******@yahoo.com> wrote in message
news:#e**************@TK2MSFTNGP10.phx.gbl...
Assuming this is an Access database (why wouldn't you think this information was relevant? Always tell us the type and version of database you are using when asking a database-related question - we are not looking over your
shoulder <grin>) I agree with Ken that this is a permissions issue. See
these articles:
http://www.aspfaq.com/show.asp?id=2062 - updatable cursor
http://www.aspfaq.com/show.asp?id=2009 - 80004005 errors

Depending on where this query is being run (in a regular page, or in the
session_onend event in global.asa), you need to give folder-level Change
permissions to both the IUSR and IWAM accounts for the folder containing the database. Do not assume these accounts are in the Everyone group (they're
not).

Also, if the database is on a remote machine, the account used to access
that database must be a domain-level account:
http://support.microsoft.com/default...b;EN-US;253580
Finally, there is a slight possibility that the query itself is at fault, so you should response.write the CommandText and see if it's a runnable query.
HTH,
Bob Barrows
Christopher Brandsdal wrote:
Hi!

I have a problem running my code on 2000 server and iis5.0.

The code runs perfectly on my localhost (xp iis5.1) but when i run it
on 2000 server iis5.0 I get this error:

--------------------------------------

operation must use an updateable query

execute_insert_text_content.asp l 83
--------------------------------------

My code looks like this:
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''

<%@ LANGUAGE=JScript %>
<% Session.LCID = 1044 %>
<OBJECT id=cn PROGID="ADODB.Connection" RUNAT="server"></OBJECT>
<OBJECT id=rst PROGID="ADODB.Recordset" RUNAT="server"></OBJECT>
<OBJECT id=cm PROGID="ADODB.Command" RUNAT="server"></OBJECT>

<!--#include file="./library/utils.inc"-->
<!--#include file="./library/adojavas.inc"-->
<!--#include file="./library/db.inc"-->

<%
Response.Buffer = true;

CheckUser(Application("UserLevel"));

var sSQL = "";

var iNodeId = FormGetInteger("iNodeId", -1);
var iLanguageId = FormGetInteger("oComboLanguageId",
-1); var iListId = FormGetInteger("iListId", -1);
var strContentTitle =
Request.Form("oEditContentTitle").Count > 0 ?
Request.Form("oEditContentTitle").Item(1) : "";
var strContentSubTitle =
Request.Form("oEditContentSubTitle").Count
0 ? Request.Form("oEditContentSubTitle").Item(1) : "";

var strContentImage1 =
Request.Form("oEditContentImage1").Count > 0 ?
Request.Form("oEditContentImage1").Item(1) : "";
var strContentImage2 =
Request.Form("oEditContentImage2").Count > 0 ?
Request.Form("oEditContentImage2").Item(1) : "";
var strDocumentLink =
Request.Form("oEditDocumentLink").Count > 0 ?
Request.Form("oEditDocumentLink").Item(1) : "";
var strDocumentLinkDescription =
Request.Form("oEditDocumentLinkDescription").Count > 0 ?
Request.Form("oEditDocumentLinkDescription").Item( 1) : "";
var strContentBody =
Request.Form("oTextAreaContentBody").Count
0 ? Request.Form("oTextAreaContentBody").Item(1) : "";

var bMoreContents = FormGetInteger("iMoreContents", 0)
== 1 ? true : false;
var Fil1 = Request.Form("Fil1").Count > 0 ?
Request.Form("Fil1").Item(1) : "";
var Fil2 = Request.Form("Fil2").Count > 0 ?
Request.Form("Fil2").Item(1) : "";
var Fil3 = Request.Form("Fil3").Count > 0 ?
Request.Form("Fil3").Item(1) : "";
var Fil4 = Request.Form("Fil4").Count > 0 ?
Request.Form("Fil4").Item(1) : "";

if((iNodeId == -1) || (iLanguageId == -1) || (iListId == -1))
Response.Redirect("./tree_cms.asp");

cn.Open(Application("ADOConnectionString"));

cm.ActiveConnection = cn;

sSQL = "SELECT content_id FROM Content_Text WHERE topic_id=" +
iNodeId; sSQL += " AND language_id=" + iLanguageId + " AND list_id="
+ iListId + " AND preview=0";

rst.Open(sSQL, cn);

if(!rst.EOF)
{
// Update
cm.CommandText = "UPDATE Content_Text SET title = ?, sub_title = ?,
body = ?, picture_file_name_1 = ?, ";
cm.CommandText += "picture_file_name_2 = ?, Fil1 = ?, Fil2 = ?, Fil3
= ?, Fil4 = ?, document_link = ?, document_link_description = ?,";
cm.CommandText += "modification_date = " + GetActualDbDate() + ",
user_name = ? WHERE content_id=?";
cm.Parameters.Append(cm.CreateParameter("title", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("sub_title ", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("body", adLongVarWChar,
adParamInput, 20480000));
cm.Parameters.Append(cm.CreateParameter("picture_f ile_name_1",
adVarChar, adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("picture_f ile_name_2",
adVarChar, adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("Fil1", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("Fil2", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("Fil3", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("Fil4", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("document_ link", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("document_ link_description",
adVarChar, adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("user_name ", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("content_i d", adInteger,
adParamInput));
cm("title") = CutString(strContentTitle, 255);
cm("sub_title") = CutString(strContentSubTitle, 255);
cm("body") = strContentBody;
cm("picture_file_name_1") = CutString(strContentImage1, 255);
cm("picture_file_name_2") = CutString(strContentImage2, 255);
cm("Fil1") = CutString(Fil1, 255);
cm("Fil2") = CutString(Fil2, 255);
cm("Fil3") = CutString(Fil3, 255);
cm("Fil4") = CutString(Fil4, 255);
cm("document_link") = CutString(strDocumentLink, 255);
cm("document_link_description") =
CutString(strDocumentLinkDescription, 255);
cm("user_name") = Session("UserName");
cm("content_id") = rst("content_id").value;
83 cm.Execute();
}
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''
line 83: cm.Execute();

Why does i work on my xp, but not on the 2000 server??????

I have also uploaded my code to another server, and it worked
perfectly there also..

Is there maby some options in iis that are set wrong???
Thanks!

Christopher Brandsdal


Jul 19 '05 #6

P: n/a
Thanks!
oops..
I forgot that when I burn the files to a cd it autmaticly makes them "read
only" when I copy them back to disc....

I AM SO SORRY :)

Thanks ALOT for helping me realize that there's nothing wrong with the
system, it's just me ;)
"Ken Schaefer" <ke*******@THISadOpenStatic.com> skrev i melding
news:O0*************@TK2MSFTNGP10.phx.gbl...
Check the permissions again!

If IUSR_<machinename> has Read/Write (RXW) then Creator/Owner needs Full
Control.
Otherwise, if you are have remove the special CreatorOwner user, then
IUSR_<machinename> needs Change (RWXD) permissions.

This is because Access needs to create the .ldb lockfile, which is created
in the same folder as the .mdb file. And it needs to delete it later on. So, either IUSR_<machinename> needs Change (RWXD) or, since it is the Owner of
the .ldb lockfile, Creator/Owner needs Change (by default, I think C/O has
Full Control).

Cheers
Ken

"Christopher Brandsdal" <ch***********@c2i.net> wrote in message
news:Oc**************@TK2MSFTNGP12.phx.gbl...
: hmm.. I have done this...
: But it still won't work!
: I think something else must be the problem..
:
: "Ken Schaefer" <ke*******@THISadOpenStatic.com> skrev i melding
: news:Op**************@TK2MSFTNGP09.phx.gbl...
: > This is an NTFS permissions problem. Give the IUSR_<machinename> account : (or
: > whatever user context you are using) Read/Write permissions to the
folder
: > (and files) where the .mdb file is, and also to the Windows temp
: directory.
: >
: > Cheers
: > Ken
: >
: >
: > "Christopher Brandsdal" <ch***********@c2i.net> wrote in message
: > news:%2***************@TK2MSFTNGP10.phx.gbl...
: > : Hi!
: > :
: > : I have a problem running my code on 2000 server and iis5.0.
: > :
: > : The code runs perfectly on my localhost (xp iis5.1) but when i run it on
: > : 2000 server iis5.0 I get this error:
: > :
: > : --------------------------------------
: > :
: > : operation must use an updateable query
: > :
: > : execute_insert_text_content.asp l 83
: > : --------------------------------------
: > :
: > : My code looks like this:
: > :
: > <snip>
: >
: >
:
:

Jul 19 '05 #7

P: n/a
Oh yeah - that's another issue I didn't even think of!

You run into this as well if you put your .mdb file inside your webroot, and
you run the FPSE "tighten security" wizard, and your .mdb file isn't inside
the "special" /fpdb folder.

Glad you got it sorted out.

Cheers
Ken

"Christopher Brandsdal" <ch***********@c2i.net> wrote in message
news:O1**************@TK2MSFTNGP11.phx.gbl...
: Thanks!
: oops..
: I forgot that when I burn the files to a cd it autmaticly makes them "read
: only" when I copy them back to disc....
:
: I AM SO SORRY :)
:
: Thanks ALOT for helping me realize that there's nothing wrong with the
: system, it's just me ;)
:
:
: "Ken Schaefer" <ke*******@THISadOpenStatic.com> skrev i melding
: news:O0*************@TK2MSFTNGP10.phx.gbl...
: > Check the permissions again!
: >
: > If IUSR_<machinename> has Read/Write (RXW) then Creator/Owner needs Full
: > Control.
: > Otherwise, if you are have remove the special CreatorOwner user, then
: > IUSR_<machinename> needs Change (RWXD) permissions.
: >
: > This is because Access needs to create the .ldb lockfile, which is
created
: > in the same folder as the .mdb file. And it needs to delete it later on.
: So,
: > either IUSR_<machinename> needs Change (RWXD) or, since it is the Owner
of
: > the .ldb lockfile, Creator/Owner needs Change (by default, I think C/O
has
: > Full Control).
: >
: > Cheers
: > Ken
: >
: > "Christopher Brandsdal" <ch***********@c2i.net> wrote in message
: > news:Oc**************@TK2MSFTNGP12.phx.gbl...
: > : hmm.. I have done this...
: > : But it still won't work!
: > : I think something else must be the problem..
: > :
: > : "Ken Schaefer" <ke*******@THISadOpenStatic.com> skrev i melding
: > : news:Op**************@TK2MSFTNGP09.phx.gbl...
: > : > This is an NTFS permissions problem. Give the IUSR_<machinename>
: account
: > : (or
: > : > whatever user context you are using) Read/Write permissions to the
: > folder
: > : > (and files) where the .mdb file is, and also to the Windows temp
: > : directory.
: > : >
: > : > Cheers
: > : > Ken
: > : >
: > : >
: > : > "Christopher Brandsdal" <ch***********@c2i.net> wrote in message
: > : > news:%2***************@TK2MSFTNGP10.phx.gbl...
: > : > : Hi!
: > : > :
: > : > : I have a problem running my code on 2000 server and iis5.0.
: > : > :
: > : > : The code runs perfectly on my localhost (xp iis5.1) but when i run
: it
: > on
: > : > : 2000 server iis5.0 I get this error:
: > : > :
: > : > : --------------------------------------
: > : > :
: > : > : operation must use an updateable query
: > : > :
: > : > : execute_insert_text_content.asp l 83
: > : > : --------------------------------------
: > : > :
: > : > : My code looks like this:
: > : > :
: > : > <snip>
: > : >
: > : >
: > :
: > :
: >
: >
:
:
Jul 19 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.