Excuse me while I express my DISGUST and FRUSTRATION at how poorly Microsoft has implemented error reporting with their OLE-DB / ODBC technology. It's impossible to know where a problem is with messages like "Multiple-step operation generated errors. Check each status value."

I'm getting an error with the RS.Update statement below (vbscript from an ASP module):

  with RS
   .activeconnection=DBCONNECTION
   .cursortype = adOpenStatic
   .cursorlocation = adUseClient
   .locktype = adLockOptimistic 
   .Source = "select * from users"
   .open 
  end with
RS.AddNew
RS.FIELDS("F1")="XXX"
etc...
RS.UpDate

...and then I get that maddening "Multiple-step operation generated errors. " message and no idea why. Can somebody please tell me just how to use ADO to add new records to a VFP table. I don't think security is an issue here. "Everyone" has full access to folders and files. Thanks very much.