Sub Query Problem

Hello all,



I am using Access as my data base and this query to update a table. (Using ASP as front end and ADODB to conenct)



"UPDATE TableEMP SET Remaining_Leaves =(Select (Remaining_Leaves + 1) from TableEMP) WHERE Remaining_Leaves < 3"



the idea is is to increment the value of Remaining_leaves inthe TableEMP table.



I am getting age old "Operation must use an updateable query" error. I tryed reffering to all the earlier thread on this error, Nothing help.



please help me on this.

can we see your connection code plz

this is my connection code



Const strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\LeaveDB.mdb;Persist Security Info=False"

Const adCmdText= "1"

dim strqueryGet, strqueryUpdate

dim Remainingleave

dim cn

dim Updatemprs,GetEmprs

Set cn = CreateObject("ADODB.Connection")

cn.open strConn, "", ""





Set GetEmprs = CreateObject("ADODB.Recordset")

Make sure the web server has write permission to your database file.