Please help! We recently upgrade our Oracle db to 11gR2. Prior to that, I could make updates to the 9i database just fine, now (after resolving a tns names issue), I am able to connect using ODBC and the MS Access database and I can see data (ie. select) but I cannot make any updates. When I try, it appears to work but when I query for the data just entered, its not there! I am not very experienced so I need help! We are using the Oracle drivers from 10.2
The most common cause for this that I've seen is that the Oracle table doesn't have a primary key, and when doing the table link in MSAccess when it prompted for a primary key the dialogue was dismissed. Without a PK the link is read only.
Try a new table link, and make sure to select pk columns if prompted