<div>
You answered my question, thanks, however I don't know &nbsp;what you you mean by &quot;editable view&quot;(remember I'm new to databases and CDao* classes). &nbsp;Anyway, I was hoping for more guidance like I web site with an example or sample code. &nbsp;By the way, I've used you book as reference for other things and think it's helpful.<br />

</div>


You answered my question, thanks, however I don't know  what you you mean by "editable view"(remember I'm new to databases and CDao* classes).  Anyway, I was hoping for more guidance like I web site with an example or sample code.  By the way, I've used you book as reference for other things and think it's helpful.


<div>
<div class="content wysiwyg-content">
I have an Access DB with 3 tables. &nbsp;I used the ClassWizard to create a class derived from the base class of CDaoRecordset. &nbsp;My goal is to write records to the three tables, however, within &quot;CDaoRecordset::GetDefault<wbr />SQL()&quot; , I am only allowed to define 1 table name to edit. &nbsp;Hence, the only solution I can clearly see is to create 3 different CDaoRecordset classes and open and close the .mdb file each time I need to switch to a different table. &nbsp;That way seems very inefficient. &nbsp;Is it possible to access different tables within the same file and class? &nbsp;How? &nbsp;I am just starting to learn about databases, so any code would also be a big help.
</div>
</div>


I have an Access DB with 3 tables.  I used the ClassWizard to create a class derived from the base class of CDaoRecordset.  My goal is to write records to the three tables, however, within "CDaoRecordset::GetDefaultSQL()" , I am only allowed to define 1 table name to edit.  Hence, the only solution I can clearly see is to create 3 different CDaoRecordset classes and open and close the .mdb file each time I need to switch to a different table.  That way seems very inefficient.  Is it possible to access different tables within the same file and class?  How?  I am just starting to learn about databases, so any code would also be a big help.

CDaoRecordset to edit multiple tables

Kernel and system programming is the process of creating the software necessary for a computer or device to function and operate other programs. Some operating systems (such as Microsoft Windows) are proprietary, but others, such as the various Linux distributions, are open source.