an Access database with 100 table in it, all of the tale have same table fields.

now i build a program to handle the database with DAO technique in vc++2008, and dynamically select any table and then add new records into it according to the need and possiblity.

in the program i use the class CDaoDB and CDaoRS inheriting from class of CDaodatabase and CDaorecordset, which is on"http://www.codeproject.com/KB/database/dao.aspx".

how to use only one instance of CDaoRS to dynamically select a table and add new record in it??/