One additional point - and this comes from the ADO Programmers Reference:

1. You cannot append new data in a shaped recordset..
2. You cannot reshape parameterized recordsets..

Again, it is powerful for viewing data in some circumstances. However, it can be difficult to manage and the syntax is brutal..