Brian Gubb
|
| Posted: 03/27/2003, 4:23 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0008_01C2F4C0.48576360
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Error description: [Microsoft][ODBC Microsoft Access Driver] Operation =
must use an updateable query. (Microsoft OLE DB Provider for ODBC =
Drivers)
My site works fine on a local publish, but when I publish remote I get =
this error message everytime I try to add or submit anything.
Your help would really be appreciated.
Brian
------=_NextPart_000_0008_01C2F4C0.48576360
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2723.2500" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2><FONT size=3D3><STRONG>Error description:</STRONG>=20
[Microsoft][ODBC Microsoft Access Driver] Operation must use an =
updateable=20
query. (Microsoft OLE DB Provider for ODBC Drivers)</FONT></FONT></DIV>
<DIV><FONT size=3D2><FONT size=3D3></FONT></FONT> </DIV>
<DIV><FONT size=3D2><FONT size=3D3>My site works fine on a local =
publish, but when I=20
publish remote I get this error message everytime I try to add or submit =
anything.</FONT></FONT></DIV>
<DIV><FONT size=3D2><FONT size=3D3></FONT></FONT> </DIV>
<DIV><FONT size=3D2><FONT size=3D3>Your help would really be=20
appreciated.</FONT></FONT></DIV>
<DIV><FONT size=3D2><FONT size=3D3></FONT></FONT> </DIV>
<DIV><FONT size=3D2><FONT size=3D3>Brian</FONT></DIV>
<DIV><BR></DIV></FONT></BODY></HTML>
------=_NextPart_000_0008_01C2F4C0.48576360--
|
|
|
 |
DonB
|
| Posted: 03/27/2003, 4:56 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0043_01C2F436.67238E70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Normally (with Access) this is due to the actual database file not being =
"writeable" from the web server. Assuming you are running Microsoft =
IIS, this message means the anonymous account "IUSR_<servername>" has =
insufficient permissions on the folder where the MDB resides.
DonB
"Brian Gubb" <b.gubb@clear.net.nz> wrote in message =
news:b5uqg6$1t3$1@news.codecharge.com...
Error description: [Microsoft][ODBC Microsoft Access Driver] Operation =
must use an updateable query. (Microsoft OLE DB Provider for ODBC =
Drivers)
My site works fine on a local publish, but when I publish remote I get =
this error message everytime I try to add or submit anything.
Your help would really be appreciated.
Brian
------=_NextPart_000_0043_01C2F436.67238E70
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1141" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Normally (with Access) this is due to =
the actual=20
database file not being "writeable" from the web server. Assuming =
you are=20
running Microsoft IIS, this message means the anonymous account=20
"IUSR_<servername>" has insufficient permissions on the =
folder where=20
the MDB resides.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>DonB</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Brian Gubb" <<A=20
href=3D"mailto:b.gubb@clear.net.nz">b.gubb@clear.net.nz</A>> wrote =
in message=20
<A=20
=
href=3D"news:b5uqg6$1t3$1@news.codecharge.com">news:b5uqg6$1t3$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT size=3D2><FONT size=3D3><STRONG>Error description:</STRONG> =
[Microsoft][ODBC Microsoft Access Driver] Operation must use an =
updateable=20
query. (Microsoft OLE DB Provider for ODBC =
Drivers)</FONT></FONT></DIV>
<DIV><FONT size=3D2><FONT size=3D3></FONT></FONT> </DIV>
<DIV><FONT size=3D2><FONT size=3D3>My site works fine on a local =
publish, but when=20
I publish remote I get this error message everytime I try to add or =
submit=20
anything.</FONT></FONT></DIV>
<DIV><FONT size=3D2><FONT size=3D3></FONT></FONT> </DIV>
<DIV><FONT size=3D2><FONT size=3D3>Your help would really be=20
appreciated.</FONT></FONT></DIV>
<DIV><FONT size=3D2><FONT size=3D3></FONT></FONT> </DIV>
<DIV><FONT size=3D2><FONT size=3D3>Brian</FONT></DIV>
<DIV><BR></DIV></BLOCKQUOTE></FONT></BODY></HTML>
------=_NextPart_000_0043_01C2F436.67238E70--
|
|
|
|
Brian Gubb
|
| Posted: 03/28/2003, 3:11 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0014_01C2F57F.4F586500
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thanks, I contacted my webserver and you were correct, they had the data =
folder as read only.
Brian
"DonB" <dbweb2@premiersi.com> wrote in message =
news:b5use8$6op$1@news.codecharge.com...
Normally (with Access) this is due to the actual database file not =
being "writeable" from the web server. Assuming you are running =
Microsoft IIS, this message means the anonymous account =
"IUSR_<servername>" has insufficient permissions on the folder where the =
MDB resides.
DonB
"Brian Gubb" <b.gubb@clear.net.nz> wrote in message =
news:b5uqg6$1t3$1@news.codecharge.com...
Error description: [Microsoft][ODBC Microsoft Access Driver] =
Operation must use an updateable query. (Microsoft OLE DB Provider for =
ODBC Drivers)
My site works fine on a local publish, but when I publish remote I =
get this error message everytime I try to add or submit anything.
Your help would really be appreciated.
Brian
------=_NextPart_000_0014_01C2F57F.4F586500
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2723.2500" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Thanks, I contacted my webserver and you were =
correct, they=20
had the data folder as read only.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Brian</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"DonB" <<A=20
href=3D"mailto:dbweb2@premiersi.com">dbweb2@premiersi.com</A>> =
wrote in=20
message <A=20
=
href=3D"news:b5use8$6op$1@news.codecharge.com">news:b5use8$6op$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Normally (with Access) this is due to =
the actual=20
database file not being "writeable" from the web server. =
Assuming you=20
are running Microsoft IIS, this message means the anonymous account=20
"IUSR_<servername>" has insufficient permissions on the =
folder=20
where the MDB resides.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>DonB</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Brian Gubb" <<A=20
href=3D"mailto:b.gubb@clear.net.nz">b.gubb@clear.net.nz</A>> =
wrote in=20
message <A=20
=
href=3D"news:b5uqg6$1t3$1@news.codecharge.com">news:b5uqg6$1t3$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT size=3D2><FONT size=3D3><STRONG>Error =
description:</STRONG>=20
[Microsoft][ODBC Microsoft Access Driver] Operation must use an =
updateable=20
query. (Microsoft OLE DB Provider for ODBC =
Drivers)</FONT></FONT></DIV>
<DIV><FONT size=3D2><FONT size=3D3></FONT></FONT> </DIV>
<DIV><FONT size=3D2><FONT size=3D3>My site works fine on a local =
publish, but=20
when I publish remote I get this error message everytime I try to =
add or=20
submit anything.</FONT></FONT></DIV>
<DIV><FONT size=3D2><FONT size=3D3></FONT></FONT> </DIV>
<DIV><FONT size=3D2><FONT size=3D3>Your help would really be=20
appreciated.</FONT></FONT></DIV>
<DIV><FONT size=3D2><FONT size=3D3></FONT></FONT> </DIV>
<DIV><FONT size=3D2><FONT size=3D3>Brian</FONT></DIV>
<DIV><BR></DIV></BLOCKQUOTE></BLOCKQUOTE></FONT></BODY></HTML>
------=_NextPart_000_0014_01C2F57F.4F586500--
|
|
|
|
|
