It would help if you explained what you are actually doing with the data.
A VBA recordset works directly with the table, as in stck taking or sales and stock etc.
But I am not sure what you are doing with your data.
ps som edummy data and an example would help a lot.
I can look at it tomorrow.