"Write Conflict"

[ARIES_XIII]

Hello MrExcel Community,

I am trying to push changes from Access to an Oracle via Access link and update query. I am receiving the "write conflict" error or an Oracle Error "ORA-01461 can bind a LONG value only for insert into a LONG column". The table in Access is a child of the oracle table and should have the same datatypes. Can anyone help?

Thank you,

Mr DataDog

 

[ranman256]

those should work fine.
but you can get the error if you are missing a key field, or indexed field that needs to be in the update. (as a where clause)

 

[ARIES_XIII]

It should work fine. The keys are setup. I also get lock violation? Any ideas?

 

[ARIES_XIII]

Something I should clarify. The "write conflict" error shows up anytime I try to make any manual changes to the table.

 

[xenou]

The table in Access is a child of the oracle table and should have the same datatypes.

Have you verified this?
Also, have you narrowed down exactly what column (or columns) are involved?