Dropped/Missing data

[Xarkath]

Hello,

I have an inventory database setup in MS Access 2010. This is a simple setup designed to track inventory by client, member, item type and dates. An item gets keyed into the table and when a rep has completed the item they close it out by applying the date completed and their initials. All straightfoward. The problem is that after a record has been marked as completed the data for record is being dropped which is to say that the row is still present in the table but all the data, including the auto number primary key is blank/Null. At first I thought someone was deleteing the data but after several attempts to do that myself all I could do was delete a complete row, I cannot simply delete the data in the row. Also, I cannot find any common denominators between the missing records, it just seems to randomly happen. There have been 3 over the last 2 days.

I would appreciate any ideas or advice regarding what might be the cause of this. If it makes any difference this is a split database and the table is being updated through the use of a frontend form. Also, the database is less than a month old and still has very little data stored in it.

Thanks

[Bob Fitz]

When strange things happen it can often be caused by corruption.