"Write Conflict"

ARIES_XIII

New Member
Joined
Mar 28, 2012
Messages
14
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
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

ranman256

Well-known Member
Joined
Jun 17, 2014
Messages
1,842
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

New Member
Joined
Mar 28, 2012
Messages
14
Something I should clarify. The "write conflict" error shows up anytime I try to make any manual changes to the table.
 

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,603
Office Version
2013
Platform
Windows
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?
 

Forum statistics

Threads
1,089,637
Messages
5,409,467
Members
403,265
Latest member
HMR120

This Week's Hot Topics

Top