A very strange thing happened to my application today. Records were locked and info appeared to disappear. I found that the problem was in my main tblOrders. OrderNumber is set as the primary key. The problem was that the primary key had disappeared completly from this table. I simply re set OrderNumber as the primary key and everything was fine.