Unanswered: Access Write Conflict Errors with Oracle Backend
I have an MS Access database that we recently moved to Oracle.
It was working fine in Access, the forms are bound to the tables - I don't use ADO or DAO to populate them.
Since we've moved the tables to Oracle and I've connected them via ODBC users receive write conflict error messages randomly, although in the second day or release more and more conflicts are occuring.
Does anyone have any idea what is wrong?
The forms work most of the time, but just the odd record gets like this and then there is nothing that can be done to make a change. Two users aren't in the same record, the database kicks them out first thing when the form loads if there is another user accessing the same record.
Any help is appreaciated.
Do you need to do commit statements when using Oracle --> Access?