I am currently now designing an application that is using ODBC as an interface. My database is MS Access. And i'm using Visual C++ to developed my front end application. I developed my front end application using the app wizard and connect it to the data source through the ODBC.
The problem i am facing right now is how do i retrieve more than one record from the recorset that belong to a particular table and move them to another table automatically.
For intance table A and Table B.
In table A i want to retrive all those records that meets the criteria. For instance :
Between monday to friday.
I want to take all those records from monday - Friday in table A to table B.
After that i want to delete all those record in table A.