ADO and Access Queries

[Vandana Sood]

I have made a query in MS access which I am trying to call from ADO.I do not get any compilation or run time error but the query does not work on execution.In debug it says ADO unable to find the object referred to by the application.I have set CommandType as CmdStoreProc.Why is the access query not being found???

[sathyanr]

Access does not support Stored Procedures instead Queries in Access are mentioned as Views..
So instead of using cmdStoredProcedure as the command type use adCmdTableDirect.