So via the comments we found that the requirement is to populate the recordset from a given dataset. The method giving the error should never be used for this purpose, so the exact error message is not relevant to the issue.
Given this new information I was able to find this page:
convert Dataset to VB recordset[
^]
Which led right back here to this article:
Simplest code to convert an ADO.NET DataTable to an ADODB.Recordset[
^]
I took a quick look and it appears to be exactly what you're looking for.
NB: OP: Try to describe your intended outcome in the question next time.
Try thinking along these lines:
- What I am trying to do
- What I expect the outcome to be
- What is the actual (unexpected?) outcome
- What I have tried
- Why i am stuck
Just a suggestion ^_^