Error 3265 mystery error



Greetings.

I'm getting an error 3265 (Item-not-found-in-the-collection type error) when I attempt to open a recordset in an Access 2000 database using adCmdTable. My code looks something like this:
Call MyRecordset.Open("tblTest", myConnection, adOpenKeyset, adLockOptimistic, adCmdTable)

The myConnection variable is an open ADODB connection object. "tblTest" is an existing table in the database. As a matter of fact, in the debug window I can use ADOX to confirm that there is a table named "tblTest" in the database. With ADOX, I can confirm that the table is there, and even iterate through the table's columns collection, etc.

Why would ADO give me an error 3265 when I try to open a recordset of the table, event when ADOX can confirm that it is there? Are there any known bugs with regard to this? Is there another error that's not getting caught by MS that's causing 3265 as a side-effect? Sometimes improperly handled errors can give rise to subsequent errors that are misleading.

Please help. Thank you.

- will f