반품
-
제목
Getting "Operation must use an updateable query" error when try to update tables using the que -
설명
Using the Query Builder, I tried to update some tables in my Oracle database using data from tables in my SQL Server database. It allowed me to update some, but others it would not. The tables are in the same database and have the same properties as the others able to update.
I am getting the following error when trying to update the problem tables:Error:20-Dec-10 11:37:41 AM 0:00:00.000: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
-
원인
Oracle table that is trying to get updated does not have primary key.
-
해결 방안
Add a primary key to the Oracle table you are trying update.