Multiple result sets from MySQL stored-procedure in MS-Access front-end using vba?

I'm familiar with using the ADODB Connection and ADODB Recordset in vba to iterate through records of a single result set from a stored-procedure from 开发者_运维问答MySQL. But I now have a stored-procedure that returns multiple result sets. How do I access all result sets? Is it even possible?

Use the ADO NextRecordset Method

See the detailed example linked on that page.