Non-updatable ODBC-connection

[Kalin]

Problem:

My Access db has an ODBC link to an Oracle db.
While the Oracle user has all privileges on the table, the linked Access db only has select privileges.

Any thoughts on what caused this behavour and how to make sure the a
Access db has all privileges on the table ??

Thanks in advance.

Gtz,

Kalin

 

[tlbroadbent]

Does the Oracle table have a primary key or unique index? Linked tables are not updatable unless Access can uniquiely identify each record. Terry Broadbent

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin