I was trying to execute the statement inside a cursor operation inside a stored procedure.
Thank you, Daniel Daniel Hutchins Woodbridge, CA have noticed that when you use ADO in VBA, this message appears when you either update the Key field, or you don't have a key field and you update the field that VBA has decided to use to uniquely identify your records.
When I added a key field to my MS Access table, my code ran several times with an error.
Cells in an update grid can be selected individually.
The header detail, headerless detail, power edit, and portlet edit forms have update grids, as do update subforms. The columns are specified at design time and are one of these types: A database column is associated with an item in the business view (BV) and through that connection to a DD item.
Use grids to display data and to enable users to enter information.
Unlike an edit control, grid controls can show multiple data items and multiple table rows at once. You are currently viewing the BOOK: Beginning Access VBA section of the Wrox Programmer to Programmer discussions.This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. I am getting the message "key column information is insufficient or incorrect.Daniel Wischnewski – Basically, this is a note to myself, but it may help you anyway. Creating a little more complex query today, I got the error message "Insufficient key column information for updating or refreshing" when trying to apply changes to the data set. The error is "Key column information is insufficient or incorrect. The statement should be updating the 'total' field to the value of '1'.Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation.