eez81
asked on
error exist when execute asp code
when i'm trying to execute the below code, there is an error exist:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/test/real.asp, line 26
HTML FILE:formtest.html
<html>
<head><title>Maklumat Produk</title>
</head>
<body>
<body bgcolor="3399cc">
<p align="center"><b><font size="5" font color="#FFFFFF">Pelajar</f ont></b></ p>
<img src="line1.GIF" align="center" width="600" height="10" >
<br>
<a href= "test.asp">[ Home ]</a>
<form action="/test/real.asp" Method=Post>
<center>
<table>
<tr><td>
<b>Matrik:</td><td><Input type="text" name="fmatrik" maxlenght="5"></b></td></t r>
<tr><td>
<b>Nama:</td><td><Input type="text" name="fnama"></b></td><tr>
<tr><td><b>Email:</td><td> <Input type="text" name="fmel"></b></td><tr>
<br>
<input type="submit" value="Sila Proses" name="B1">
<input type="reset" value="Sila Bersih" name="B2">
</form>
</body>
</html>
ASP FILE: real.asp
<html>
<head>
<title>Produk</title></hea d>
<body><body background="_themes/blends /blegtext. gif" bgcolor="#CCCCCC" text="#000000" link="#993300" vlink="#0000FF" alink="#FF9900"><!--msnavi gation-->< table border="0" cellpadding="0" cellspacing="0" width="100%"><tr><td><!--m stheme-->< font face="Trebuchet MS, Arial, Helvetica">
<center><h1><font color=blue>Proses Rekod Baru</font></h1><p>
<hr>
<%
matrik =Request.Form("fmatrik")
nama =Request.Form("fnama")
mel =Request.Form("fmel")
set db=Server.CreateObject("AD ODB.Connec tion")
db.Open"eez"
VQ="INSERT INTO zee ( "
VQ=VQ+ "matrik, "
VQ=VQ+ "nama,"
VQ=VQ+ "mel) Values (' "
VQ=VQ+ matrik+" ',' "
VQ=VQ+ nama+"','"
VQ=VQ+ mel+"')"
db.Execute VQ
db.Close
%>
<p><blink><h3>Data sudah direkodkan!!</h3></blink>
<p><hr><br><br>
<u><h3>Butir-butir yang anda masukkan adalah seperti berikut:</h3></u><p>
<dir><pre>
<table><tr><td>
<tr><td>Matrik </td><td>=<%=matrik %></td></tr>
<tr><td>Nama </td><td>=<%=nama %></td></tr>
<tr><td>Mel </td><td>=<%=mel %></td></tr>
</table>
</pre>
</dir>
</body>
</html>
why this happened??what should I do?plz help me....thank you...
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/test/real.asp, line 26
HTML FILE:formtest.html
<html>
<head><title>Maklumat Produk</title>
</head>
<body>
<body bgcolor="3399cc">
<p align="center"><b><font size="5" font color="#FFFFFF">Pelajar</f
<img src="line1.GIF" align="center" width="600" height="10" >
<br>
<a href= "test.asp">[ Home ]</a>
<form action="/test/real.asp" Method=Post>
<center>
<table>
<tr><td>
<b>Matrik:</td><td><Input type="text" name="fmatrik" maxlenght="5"></b></td></t
<tr><td>
<b>Nama:</td><td><Input type="text" name="fnama"></b></td><tr>
<tr><td><b>Email:</td><td>
<br>
<input type="submit" value="Sila Proses" name="B1">
<input type="reset" value="Sila Bersih" name="B2">
</form>
</body>
</html>
ASP FILE: real.asp
<html>
<head>
<title>Produk</title></hea
<body><body background="_themes/blends
<center><h1><font color=blue>Proses Rekod Baru</font></h1><p>
<hr>
<%
matrik =Request.Form("fmatrik")
nama =Request.Form("fnama")
mel =Request.Form("fmel")
set db=Server.CreateObject("AD
db.Open"eez"
VQ="INSERT INTO zee ( "
VQ=VQ+ "matrik, "
VQ=VQ+ "nama,"
VQ=VQ+ "mel) Values (' "
VQ=VQ+ matrik+" ',' "
VQ=VQ+ nama+"','"
VQ=VQ+ mel+"')"
db.Execute VQ
db.Close
%>
<p><blink><h3>Data sudah direkodkan!!</h3></blink>
<p><hr><br><br>
<u><h3>Butir-butir yang anda masukkan adalah seperti berikut:</h3></u><p>
<dir><pre>
<table><tr><td>
<tr><td>Matrik </td><td>=<%=matrik %></td></tr>
<tr><td>Nama </td><td>=<%=nama %></td></tr>
<tr><td>Mel </td><td>=<%=mel %></td></tr>
</table>
</pre>
</dir>
</body>
</html>
why this happened??what should I do?plz help me....thank you...
And this one also.....
http://www.learnasp.com/learn/FAQdbUpdate.asp
All the best,
V.Thandava Krishna.
http://www.learnasp.com/learn/FAQdbUpdate.asp
All the best,
V.Thandava Krishna.
Hello,
========================== ==========
FAQ #1:Operation must use an updateable query.
I get this error message when adding or modifying data
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Database Error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
is a very common error message when updating Access databases. Since Access is file based any attempt to update the database by an ASP script can only modify the Access databases if permissions are established correctly.
Go to the parent directory where the database is stored. Click on the folder permissions and set IUSER_xxxxx to 'change' where xxxxx is the machine name. Make sure the file is also set so the ISUSER_xxxx can change the file.
http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP
shows some other causes besides permissions.
========================== ========== =
All the best,
V.Thandava Krishna.
==========================
FAQ #1:Operation must use an updateable query.
I get this error message when adding or modifying data
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Database Error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
is a very common error message when updating Access databases. Since Access is file based any attempt to update the database by an ASP script can only modify the Access databases if permissions are established correctly.
Go to the parent directory where the database is stored. Click on the folder permissions and set IUSER_xxxxx to 'change' where xxxxx is the machine name. Make sure the file is also set so the ISUSER_xxxx can change the file.
http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP
shows some other causes besides permissions.
==========================
All the best,
V.Thandava Krishna.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
are u trying to upadate a view/query?
is the mdb file accessable for the Internet Guest account (IUSR_MACHINE) ?
does the table have indexing and a primary key defined?
is the dsn read- only?
is the mdb file accessable for the Internet Guest account (IUSR_MACHINE) ?
does the table have indexing and a primary key defined?
is the dsn read- only?
ASKER
i don't know where is Internet Guest account(IUSR_MACHINE) and dsn .plz give me the specified step.tq..
right click on the mdb file select properties
navigate to the security tab
click add
select the IUSR_Machine
click ok
now select the IUSR and give full control to the user
navigate to the security tab
click add
select the IUSR_Machine
click ok
now select the IUSR and give full control to the user
ASKER
what do you mean by mdb file.it is my access file i'm create or it is a program??
MDB is your access file. Right click on it. Select Properties. Select Security Tab.
Click the Add button. Select IUSR_<Your Machine Name> user. Give full control to the selected user.
All the best,
V.Thandava Krishna.
Click the Add button. Select IUSR_<Your Machine Name> user. Give full control to the selected user.
All the best,
V.Thandava Krishna.
the extention of your access file is mdb so i mean the access file ie the database file
oops too late ;-)
eez81 : you surely could select a proper answer. you should have selected the earlier comment which is the answer.
Go through the link below. You will get solution...
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q175/1/68.ASP&NoWebContent=1
All the best,
V.Thandava Krishna.