I am trying to represent a recursive relationship in an Access table in a
MSHFlexGrid control... The easiest way I see is to get a hierarchial recordset
with the SHAPE command, and bind that to the control. This works beautifully
from SQL Server, but I can't get Access to take the SHAPE commmand.

How would one go about getting a hierarchial recordset out of Access?

If there is a better way to represent a recursive relationship in a MSHFlexGrid,
I'm open to that too, but quick & dirty is the key... Also, the control automatically
sets up expanding/collapsing when it's databound to a hierarchial recordset...
I'd rather not have to code those behaviors...

Thanks!