Disappearing records

[Guest]

I am nearing the end of developing a small database for departmental use and
it is being tested by a few colleagues. Yesterday I returned after a days
leave and found that about 70 records had disappeared from one table though
the other tables seem to be intact. There are no deletion queries in the
database. One of the testers say they made changes to records but did not
delete anything and never saw any deletion warning messages.

Does this sound familiar to anyone? Is there any way that data changes can
be tracked?

Thanks,
Graham.

 

[Van T. Dinh]

Yep: some testers deleted the Records in error and won't admit the errors.
It is also possible to modified the Records without realising so as well.

Unless you implemented audit trail (not trivial), there is no way, AFAIK,
that you can trace Record manipulations.

 

[Ron2005]

Another possibility. If you have so forms/subforms that allow for
deletions (which is the default), the user may have selected a bunch of
records to perhaps copy and paste into a spreadsheet and then
accidentally hit the delete key and/or the <Cntrl-X> instead of the
<Cntrl-C>.

I had a user do this on me and it wiped out 90% of my main table.
Delete warnings may be set off somewhere else in the app and never
turned back on.

I went back and double checked all of my forms - especially datasheet
forms - and created my own delete confirmation on those few forms that
allowed deletions.

Ron