ACCESS child table has the same two records of foreign key corresponding to the parent table a primary key, in the following table:
The parent table
The primary key
1

Child table
The foreign key on the primary key field 1
1
1

When running a
Rs. Fields (Fields "1")="name"
Rs. Update
Times wrong: key column information is insufficient or incorrect, the update affects multiple lines,
Excuse me each teacher what reason is this? thank you

CodePudding user response:

Database are not allowed to exist two identical data records, if present, these two records will not be able to make any operation

CodePudding user response:

Best can have part of the data, so intuitive

CodePudding user response:

Rs. Updatebatch adAffectAll
Or directly with the Connection. The execute "update tablename set field [1]='name' where conditions"