Insufficient base table information for updating or refreshing

[bgabel]

I'm writing a form with a DataGrid and an ADODC to allow users to update Oracle database tables. These tables are relational lookup tables, but you can update them without violating referential integrity.

I set the ADODC to connect to Oracle via ODBC. I can get the Oracle table records into the DataGrid without a problem. However, if I update a field or add a new record, I get the subject line as an error message. I suppose I'm not providing Oracle or ADODC without something it needs, but I don't know what.

Selected properties are:

CursorLocation: adUseClient
CursorType: adOpenStatic
LockType: adLockOptimistic
Mode: adModeReadWrite

Thanks.

[Clunietp]

Are you selecting the primary key when you are getting your recordset? Does your base table have a primary key?

[bgabel]

The table has a primary key. Regardless of what field I try to update, I receive this error. The table is simple: 4 fields, one primary key. A foreign table uses this table as a lookup.

[bgabel]

The form I am creating is part of a larger application. When I integrated the form into the application and used the established global connection string, the datagrid updated records properly. I did not receive an error message. I still don't know why the form wouldn't update records when run stand-alone, but as long as it works with the application, I'm satisfied. Thanks for your help.