AnsweredAssumed Answered

What is causing a table to drop records?

Question asked by TomEdge on Sep 2, 2015
Latest reply on Sep 2, 2015 by schamblee

Of 42 tables in my database, one has a habit of dropping a record about once every six months.  This table is an Employee list and rarely changes, but is used for access control to the database so about once every six months someone is unable to use the application because their employee record has just disappeared.  There are no delete script steps associated with the table and no relations that could cascade down a delete.  On one occasion all records disappeared from the table and no one could log into the app.  Could there be any record locking conflict or something else that would cause a record to just disappear?  None of the other tables in the database exhibit this behavior.

Outcomes