[Access] Ado - refresh my memory

Hi,

Connecting to an Acces mdb via ado. If I want to open a query, do I use adcmdStoredProc or adCmdTable...

I just tried it and table works, stored proc didn't. But just to refresh my memory on why.

Is it necessary to use either? Wouldn't just using DoCmd.RunSQL strSQL work?