Recently when attempting to manually or programically delete more than a single line from a linked table Oracle in MS Access I have been getting the error ORA-01460.
This is a new error and may be because we have upgrade the Oracle database (11g) that is being linked to or it might have to do with the upgrade of my computer to Windows 7 with new ODBC links.
We are using MS Access (XP Pro) to link (via ODBC) to tables in the Oracle database via ODBC (Oraclient 11g). I am able to perform a delete command using SQL Tools 1.5 on the same computer. So I believe that the problem must be in the ODBC connection but I am unable to work out why or find anyone who has had a similar problem.
I could understand (to a degree) if I were to try and delete something and the “WHERE” criteria were inconsistant with the table syntax, however this should produce a different error. The error occurs when I select two or more records using the table view in Access and hit delete. I am also getting the error: “The Microsoft Jet engine stopped the process because you and another user are attempting to change the same data at the same time.” Which is basically nonsense as I am the only one logged into the database!
Any help would be greatly appreciated.