Hi,
I am facing a small problem with ADO
I have created the following recordset

SELECT empid_em as EmpID,divcode_em,wrkshpcode_em,wrkcntrcode_em,actualcode_em,ticketno_em as TicketNo, empname_em as EmpName, 1 as AvailMins,2 as IsActAlloted FROM EMPMASTER WHERE 1=2 rsEmployee.Open strQuery, dbConn, adOpenStatic, adLockBatchOptimistic

in the above recordset AvailMins and IsActAlloted columns are not available in the database, but I required them so i created Dummy Columns.

Now in a loop I assign values to AvailMins and IsActAlloted fields, using Addnew and Update method. With Oracle 8i everything works fine, but when I use the same thing with MS Access or Personal Oracle it gives an error saying
"Multiple-step operation generated errors. Check each status value."

Why is this error comming and I am not able to solve the problem.
If possible explain the problem.


Amol