Simple recordset consists of a single recordset element containing a collection of record elements, with each record containing only fields –Hierarchical recordset contains a collection of nested simple recordsets. There is no limit to the number of recordsets that can be nested within one another