Error modifying record in ESS database
I'm a newbie user of FM Pro 10 (Mac), connecting to an oracle database using ODBC. The database was set up by our IS department for a project I administer and resides on their server.
I've added a table from the database using File->Manage->Database..., and I can add records to it. The problem I have is that if I try to modify a record, I always get the error "This record was modified by another user since you started editing it." even if no one else is accessing the database. I have no idea how to troubleshoot this or figure out what it is about my configuration that is causing this. Any suggestions greatly appreciated.