Multiple-step OLE DB Error

This is a generic error message that doesn't provide much info.
Post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.

Sami,
If I may recommend some things to look at:-

1. If the query related to the table you are adding links to another table or query, and they don't share a common Master/Child key then the Add can fail.
   2, If the query points to another query which uses aggregate functions like "Group By" or "Max/Min" in any way, or a sub-query does, then you can get this error.
   
2. If you have a calculated or derived field in your query and its still checked in the Fields list as being Editable or available to Add then uncheck it.
   
3. If any sub-query has a field presented for List then it has to be unticked as being an editable or addable field in the Fields list because the database handler may not be able to update all tables.
   
4. If you are using SQL server and a query then make sure the "TOP 100" phrase isn't present in the query. In SQL server you can untick it in the Properties.
   I've been there several times and all my problems fell into 1-5 in some way.
   Regards
   

   
   

   
   Hi,
   I am getting following error while adding (Clicking save button) master details record, can someone guide me what to be checked to resolve this error.
   ------------------------------------------------------------------------------------------------------------------
   
   <<< Record was NOT added >>>
   Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
   
   ------------------------------------------------------------------------------------------------------------------
   thanks & regards
   
   Sami