DAO to call MSAccess parameterized Query
Posted on 1998-10-03
How to use DAO (CDaoRecordset) to call a parameterized query in MS Access? Can this be done? CDaoRecordset doesn't seem to work on predifined queries in Access, only on whole tables. Have previously coded the whole application using ODBC and CRecordset. This works but its really slow. Much of the application business logic is stored in Queries in an Access database. Can these queries be used in CDaoRecorset. I tried using CDaoQueryDef to open the daorecordset with but not having much luck. This should be as easy as it was using CRecordset!