Creating and operating tables by ODBC

Hello!
In access 2003,I want to add a few recordset to several tables one by
one. Now I use class CRecordset to addnew record,but it tell me the
table is read only.This is why ? Is it possible to add record to
several tables? I also feel confused how to create a table when meet
some condition??
thank you very much.

re: Creating and operating tables by ODBC

On 19 May 2005 02:10:43 -0700, mapf001@163.com wrote:

If a table has no primary key, Access will consider it readonly.
-Tom.

[color=blue]
>Hello!
>In access 2003,I want to add a few recordset to several tables one by
>one. Now I use class CRecordset to addnew record,but it tell me the
>table is read only.This is why ? Is it possible to add record to
>several tables? I also feel confused how to create a table when meet
>some condition??
>thank you very much.[/color]

re: Creating and operating tables by ODBC

Thank you ! But it still doesn't work. I create three tables in a
database, table1, table2, table3, I Want to addnew record in the table
i choose .Now i have a CRecordset-derived pointer for the tables, but
when i add record it tell me the recordset is readonly. I am confused
why??when there is one table it work freely??