Disappearing Data??!!!

[AnnaZ]

We have an MS Access 2003 database, which is accessed by several users that enter data, but usually it's one user at a time. I've been getting complaints about users entering data and then if we check for it later, it's not there. It seems to happen randomly and not to all the data, just a few records here and there. And there aren't any error messages.
Just wondering if anyone knows what the possible causes for such data loss might be and if there's anything I can do to prevent it or at least how can I determine what's causing this.

thanks in advance for your help!

Anna

 

[rainman89]

i had a similar problem when i was using action queries in my db, append and delete, sometimes records were not getting appended but were being deleted.

do you have any action queries running?

 

[AnnaZ]

No, no action queries. Just a form that is linked to a table.

thanks.

 

[MadSmoke]

Hi AnnaZ - don't know if this helps (and please excuse me if I am teaching to suck eggs). I had a similar prblem a few months ago. I added a whole lot of 'Event Logging' to the form. This wrote to a seperate table, every key click and the value of data entered for every control (including the user id) for the particular form. Took a little while but helped, in the end created (as best as possible) the scenario in which the data dissapeard.

In the end I traced this particular problem to the difference between the value stored in Me.ComboBox.Value and Me.ComboBox.Column (0))

MS

 

[Pat Hartman]

The most frequent causes of "lost" records are:
1. Missing or improper master/child links so that the child records become orphans. This can be prevented by proper use of referential integrity, required fields, and default values.
2. Use of DoCmd.Close to close forms. If the pending record has an RI error, it will prevent the record from being saved. The record is discarded without an error message. To get past this problem, save the record before issuing the close -
DoCmd.RunCommand acCmdSaveRecord
DoCmd.Close acForm, Me.Name