migrated from access - added primary keys but get record set not updateable
I used the migration workbench and successfully migrated my access database to oracle (8.1.7.3). I added a field called obj_id and made it a primary key of type autonumber prior to using workbench for each table that did not have a primary key.
However, when I try to update using my old access forms, I get the message "This record set is not updateable."
I did notice one thing. When I log in thru sql plus, I can see the obj_id primary key defined on the oracle table. But when I go into access and look at the tablename_R (oracle table), obj_id shows up as type number, not autonumber as it was defined in the tablename_L (access table). Which I guess is ok, but the little key symbol to the left that denotes the primary key doesn't show up like it does in the tablename_L table.
Any ideas/comments will be appreciated. Thanks.