Well I see it now in the quotes test of the original post.
Ah . you set the font color to yellow and I could not see it.
Try using an actual SQL statement not just a table name. That will work with DAO and JET. AFAIK
JET will translate the table name to a valid SQL statement for you. This is not true with ADO.
.Open "Select tblReportData.* from tblReportData;", cnShips, adOpenDynamic, adLockOptimistic