Ohhh, the DAO can manipulate hierarchical databases just fine. I've got procedures for adding indexes, adding relationships, and many more. Also, it fully supports cascading deletes and pretty much the full gamut of features available on native MS-Access databases. The only downside to the DAO (that pushes me to the ADO) is its inability to hook up to a SQL server on a WAN. And that's why I use both the DAO and the ADO.

Best Regards,
Elroy