Hi All.. i'm not a ASP programmer,

[sgdragon78]

Hi All.. i'm not a ASP programmer, just being assigned to maintain a site.
Recently i move a folder (by accident) to another location, and realising the mistake i move it back. After that everything seems to go wrong
First i cant do an insert or update query, it will gives me:
=======================ERROR MSG=====================
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.

/qhse2/SIN_SPB/QT_Result.asp, line 115
======================================================
If i set the access rights of EVERYONE for that mdb file, i cant even do a read operation, i will get another kind of errors:
=============ERROR MSG================================
Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.
======================================================

My codes:
<%
Set cConnLocal = Server.CreateObject (&quot;ADODB.Connection&quot
cConnLocal.Open &quot;Provider=Microsoft.Jet.OLEDB.4.0; Data Source=&quot; & Server.Mappath(DB_Local) & &quot;;Persist Security Info=False;&quot;
.. .. .. .
Set rData = cConnLocal.Execute (&quot;SELECT * FROM Quiz ORDER BY ID&quot
%>

I'm using ASP and Access DB, running on NT 5.0
Please help, this is an important application, seems like everyone in this office have to complete the test to get their year end bonus, imagine their anger now~~~

 

[multiplex77]

What is the code at and around
/qhse2/SIN_SPB/QT_Result.asp, line 115

 

[GaryC123]

You need to give the IUSR account read/write permissions on the folder. Right click, Properties, Security Tab

http://www.intouchmedialtd.com