ODBC Connections to Oracle Backend

[Val]

In access we are using an ODBC connection to an Oracle Database. But we cannot insert new rows into a table. The DBA here says it's not an Oracle Issue becauase we have full permissions on the table. How to change the security in Access? (If this is actually the problem.)

TIA

 

[Pat Hartman]

If the issue is not security then it may be that the Oracle table does not contain a primary key. Only ODBC tables with primary keys are updateable. You should also make sure the data types are compatable with Access and that you are not supplying a value for an identify field unless you have that feature enabled.

 

[HJAMES]

#Deleted# errors with linked ODBC tables

I also have an ODBC connection to an Oracle table. I'm using Triggers to generate the Primary Key. Occassionally when inserting a new record into the database I get #Deleted# in all fields. We've tied using dbSeeChanges with no luck.
Something about missing the primary key value. I'm using Access XP/ Windows XP.