Strange one... I am linking to an Oracle table via Microsoft ODBC driver. When I attempt to edit "some" records, I get a write conflict error message. I am not given the chance to save anyway. But, If I write an Update statement in Access, I can overwrite existing values in the Oracle table and I do not get the Write conflict error message. Wierd? Any clues are helpful! tia...
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Write Conflict - MS Access Linked to Oracle Tables? 1
- Thread starter smedvid
- Start date
-
1
- #2
One possibility is that you are getting round off errors in the data conversions to and from Oracle. As I understand it, when you pull Oracle data into MS Access for editing, Access doesn't put locks on the Oracle data. Instead, at the time of update, it uses a where clause in the update statement to insure that the Oracle data being updated is the same as when it was first read. If the values don't match, Access issues the "write conflict" error. Unfortunately data conversions to numeric may introduce round off or truncation errors that make it appear that data has changed, when in reality it's still the same.
- Status
Similar threads
- Locked
- Question
- Locked
- Question