Hello
I have a datagrid linked to a query in Access. I can use this query to
delete records from within Access but when I try to do the same from the
datagrid I get the message 'Insufficient key column information for updating
or refreshing'. However it lets me edit the records. I have 'AllowDelete'
ticked in the datagrid's properties but this makes no difference
Can anyone offer an explanation
Thanks
Ian
Mark J. McGinty - 29 Aug 2005 19:05 GMT
> Hello
> I have a datagrid linked to a query in Access. I can use this query to
[quoted text clipped - 5 lines]
>
> Can anyone offer an explanation
DataGrid works best when bound to a client-sided batch cursor-based
recordset:
rs.CursorLocation = adUseClient
rs.LockType = adLockBatchOptimistic
-Mark
> Thanks
> Ian