Error when deleting records

[jotaeleele]

Hi everybody!




I'm desperate with the following issue. We have an access application to manage the attendees to events. Our users can modify the status of the attendees and even delete records as needed. This Access application has all its tables linked to an Oracle database. We've got one user, and only one, that whenever tries to delete a record, the following error appears: The Microsoft access database engine stopped the process because you and another user are attempting to change the same data at same time.


The rest of the users have no problem deleting records. The error appears even if that user is the only one that is working with the application. These are the data of our environment:
All user's computers: Windows 10, Access 2010 32 bits, Oracle instantclient 12.1 32 bits
Server: Oracle 19


Any help will be highly appreciated.


Thanks and regards,

[ranman256]

is it possible they have another screen open that has the record locked? (it thinks there are 2 people editing)

also, oracle may not let you sit on the record , then press delete. (lock) ,so instead, run a delete query using the KEY as criteria.
delete * from table where [id]=forms!fMyForm!txtID

[jotaeleele]

Thanks for your answer, ranman256. This is what we did to solve this issue: there was an Oracle environment variable that all users had defined in their Windows computers except the one having the deletion problem in Access. After adding NLS_LANG with the value SPANISH_SPAIN.WE8MSWIN1252 everything worked fine. As you know, this variable is essential for Access users working in a Spanish environment with linked tables to an Oracle database. Without it, the special characters read by Access in forms do not show correctly, for example those with an accent.
Thanks again and regards,