I'm using a Data Grid 6.0 SP5 (ODBDC) control to display the results of an
Access 2K query through an ADODC control. I'm also using bound text boxes
to the ADODC control for user and programmatic updating. My problems are
1: The Data Grid control is not displaying values for the key fields of
my Access table. Other fields display correctly, but not the three fields
of the composite key. Those data grid fields remain blank I have used the
Retrieve Fields function several times on the Data Grid to ensure that I
have the correct field names there with no effect on the problem.
2: Using a Data Combo (ODBDC) control and bound text controls result in a
"Binding Collection Error" message box popping up and saying "Field not
Updateable, Bound Property <name>, Field Name <name>" the moment I add a new
record and attempt to put values in these key fields. The property and
field name appear correct, but will not let me place my data in these key
fields. Two of the fields are Foreign Keys, but even when I removed the
relationships to make the table standalone, the problem remained.
Note that executing the addnew method to the recordset does add a new row to
the Data Grid, and non-key fields are inserted correctly. But the moment
any key field is attempted to be updated, the Binding Collection Error box
The deadline on the project is fast approaching. I would appreciate any
assistance on what is happening here.