Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: insufficient key column information
In article <1f1d904a.0302271141.31a8f896_at_posting.google.com>,
bangorme_at_hotmail.com says...
> My project originally had a VB frontend and a MSAccess backend. Now
> I'd like to migrate it over to a Oracle backend and use the ADO code
> from the original frontend. I've had lots of problems, but the latest
> has got me stumped. When I try to update using an altered recordset,
> I get an "insufficient key column information for updating or
> refreshing" error. I haven't changed anything, so I'm not sure what
> key is being talked about.
>
> Any ideas would be appreciated.
>
If you are joining 2 or more tables in your recordset, you need to be
sure that all primary keys and foreign keys from all tables are
available. Otherwise you'll get that pesky error and you can't update
the recordset.