Insufficient key column information for updating
Properties("Unique Table") = "tablename" In that case, updating or deleting a row will only apply to "tablename" However, I think this property is only available with ADO 2.1 (i 'm not sure). Exactly the same situation, but I'm using a SQLServer6.5 stored procedure returning the Primary Key/Identity col and one other which gets updated. Insufficient key column information for updating or refreshing Hi, hope somebody can help. Adodc error: Insufficient Key Column Information for Updating or Refreshing 4. Insufficient key column information for updating or refreshing 6. Adodc error: Insufficient Key Column Information for Updating or Refreshing 8. HELP: 80004005 Insufficient key column information for updating or refreshing 10.
I am selecting all of the key columns plus one non-key column from one table. You could also use the "Unique table" property, like: ado RS.
It kinda makes sense what it is doing, you selected data from three tables into a recordset, when you delete a row from the recordset, it tries to delete from all the base tables. I suspected that as the problem, so just as a test, I changed the querey to be a very simple one. John Poe Since the user would delete records very rarely in my program, I created a delete procedure that opens a separate recordset containing just one table, then I moved to the record that I want to delete and deleted it.
My guess is this is NOT the functionality you are looking for. I never found a way to do this through the datagrid, I ended up doing the deletes myself. I guess that the best solution would be to open a new recordset containing only the primary table and then delete from there. I'm getting this same problem - also with a complex SQL statement - a join of two tables.
Tuition scholarships now available for 2-day course 5. Insufficient key column information for updating or refreshing 11.
Yet I still am having this error when I call the Update method of my Recordset object. Does anyone have any ideas as to how I can fix this? using free flexgrid object in Microsoft Access 97 3. Insufficient Key Column Information for Updating ot Refreshing 4. Insufficient key column information for updating or refreshing 8. Adodc error: Insufficient Key Column Information for Updating or Refreshing 10.
Should I have all the table B composite key fields in the select query? Inung Huang "Brian Bushay Team B" Does the table you are joining to have a primary key? If the joined to table doesn't have a primary key or has more fields in the key than you link to ADO will not be able to identify the joined to record.
I want, after adding that record, to check what was the new sequence number (= identity, autonumber). Well I decided to get fancy and try and load two combos at once. I am building an Application form and a few of the combo options that apply to the applicant also apply to the spouse (ie. So I figured what the HEY since they are coming from the same table I'll load the Applicants combo and the Spouse's all at the same time. As proof of my dum-dum move here is the code: Public Sub Load Combos()Dim ado Combo As ADODB. Properties("Update Resync") = ad Resync Auto Increment rs. Insufficient key column information for updating or refreshing.
Move Next Loopcbo Pgm Code = s Code'LOAD Eligibility CODESado RS4.