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

<head><title>Maklumat Produk</title>
<body bgcolor="3399cc">
<p align="center"><b><font size="5" font color="#FFFFFF">Pelajar</font></b></p>
<img src="line1.GIF" align="center" width="600" height="10" > 

<a href= "test.asp">[ Home ]</a>
<form action="/test/real.asp" Method=Post>

<b>Matrik:</td><td><Input type="text" name="fmatrik" maxlenght="5"></b></td></tr>

<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>

<input type="submit" value="Sila Proses" name="B1">
<input type="reset" value="Sila Bersih" name="B2">


ASP FILE: real.asp

<body><body background="_themes/blends/blegtext.gif" bgcolor="#CCCCCC" text="#000000" link="#993300" vlink="#0000FF" alink="#FF9900"><!--msnavigation--><table border="0" cellpadding="0" cellspacing="0" width="100%"><tr><td><!--mstheme--><font face="Trebuchet MS, Arial, Helvetica">

<center><h1><font color=blue>Proses Rekod Baru</font></h1><p>


matrik            =Request.Form("fmatrik")
nama            =Request.Form("fnama")
mel            =Request.Form("fmel")

set db=Server.CreateObject("ADODB.Connection")

VQ=VQ+ "matrik, "
VQ=VQ+ "nama,"
VQ=VQ+ "mel) Values (' "
VQ=VQ+            matrik+" ',' "
VQ=VQ+            nama+"','"
VQ=VQ+            mel+"')"
db.Execute VQ

<p><blink><h3>Data sudah direkodkan!!</h3></blink>
<u><h3>Butir-butir yang anda masukkan adalah seperti berikut:</h3></u><p>
<tr><td>Matrik                  </td><td>=<%=matrik %></td></tr>
<tr><td>Nama                  </td><td>=<%=nama %></td></tr>
<tr><td>Mel                  </td><td>=<%=mel %></td></tr>


why this happened??what should I do?plz help me....thank you...

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Thandava VallepalliCommented:

Go through the link below. You will get solution...

All the best,
V.Thandava Krishna.
Thandava VallepalliCommented:
And this one also.....

All the best,
V.Thandava Krishna.
Thandava VallepalliCommented:

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.
shows some other causes besides permissions.

All the best,
V.Thandava Krishna.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Thandava VallepalliCommented:
Hello eez81,

If you satisfy with my answer pl. don't forget to accept the answer.  Your previous question still open.   i.e   "ASP on UNIX server"

1 11/16/2003 35 error exist when execute asp code  Open Programming
2 11/09/2003 125 ASP on UNIX server  Open Web Development

All the best,
V.Thandava Krishna.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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?
eez81Author Commented:
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
eez81Author Commented:
what do you mean by mdb is my access file i'm create or it is a program??
Thandava VallepalliCommented:
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.
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.