Table record deletes itself when database left open

[starson79]

Right I'll try again - just lost the previous post.
I wasn't sure what search terms to use to research this problem so I'm hoping that someone here will have some ideas.

I've got an Access 2003 database. A user might have a project record open in the database - and then navigate away / leave the database open - come back to it and realise that the table record has deleted itself. (DELETED# appears in the bound form controls).

When I check the back-end table it has indeed lost the project record - to rectify this, the only way to retrieve the record is to re-insert the project ID - and it links with the other various tables that hold related info. Of course, any info in the primary table is lost.

I briefly researched corrupted tables and databases. The database has been known to corrupt many times - and these are automatic backup database files to prove this. I'm working on a new database to replace this one - until then what can I do to ensure this record deletion is limited?

Thanks

 

[CBrighton]

Firstly, I'd start by seeing if creating a new .mdb file and importing all the objects stabalises things at all.

It's easy to do and can sometimes help if you have had corruption on the current .mdb.

If it really is over time each time it might also be worth either actively testing it (seeing how much time and whether it's consistent or random) or going through each form to check for any timer events which may be causing problems.