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