Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Table records are being deleted for unknown reason
1 view
Skip to first unread message
Bruce
Nov 14, 2007, 3:39:03 AM11/14/07
to
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).
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
Bewilly
Nov 14, 2007, 2:50:12 PM11/14/07
to
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.
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.
Pieter Wijnen
Nov 14, 2007, 3:16:58 PM11/14/07
to
*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)
Make a Backup copy of the Db & do a Compact & Repair (should be done
regulary)
Pieter
"Bewilly" <u39062@uwe> wrote in message news:7b371c355709e@uwe...
0 new messages