Update Recordset Errors

[pengprog]

After some problems here and there, I feel as if I have reached a wall with this error I have been getting when trying to do a RecordSet.Update

Microsoft Cursor Engine error '80004005'
Insufficient base table information for updating or refreshing.

The error is in the line that I call my update and after doing some searching on the internet it seems this is a bug or some sort...I am hosting my ASP, VBScript Files on an NT Server and querying Dbase 5 tables.

 

[pengprog]

Here is a bit of the code. It works fine when running in WinXP...

Set RS = Server.CreateObject("ADODB.Recordset&quot
sql = "SELECT * FROM BEMIMA.DBF WHERE UNAME = '" & Session("USERNAME&quot & "' AND PW = '" & Session("PASSWORD&quot & "'"
RS.CursorLocation = adUseClient
RS.Open sql, objConn,adOpenStatic,adLockOptimistic

If not RS.EOF then
'update the record

RS("PW&quot = new_pass
RS.Update
Session("password&quot = new_pass