Table records are being deleted for unknown reason

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a MSAccess 2003 database which is losing records from one of its
tables (i.e. they are there 1 day but not the next).

The user who maintains the data says they are not deleting the records and
they are not getting any error messages. When they run reports they notice
items are missing from time to time. Also, there is only 1 user who acessess
this database.

The database is hosted on a remote server on an intranet and has an average
to slow response time (depending on traffic), even so the database is small
under 2mb.

Anyone come across anything like this before?
What are some options to diagnose and solve the problem?

Bruce
 
Data does not mysteriously disappear. Someone (unknowingly or knowingly) is
deleting data either manually or there is some code that is triggering this.
You need to watch whoever is maintaining the data step by step.
 
*could* be a sign of corruption (caused by bad Network card et al)
Make a Backup copy of the Db & do a Compact & Repair (should be done
regulary)

Pieter
 
Back
Top