B
Barry Glenn
I have a table in a multi-user Access 97 SR2 database that is missing
records. I checked a backup of the database and the records I suspected
were missing existed in the backup. I am sure its not a logic error because
the table has records inserted into it and there is no code to delete
records or forms bound to the table.
This is obviously alarming and I have the following concerns I would
appreciate any guidance on:
1) How did the data get lost in the first place? The database has required
a number of repairs and I am wondering if the data could have been lost
during a compact/repair. Please note there was no indication of lost data;
i.e., no #error values in table fields, etc. The data has just disappeared.
2) How do I know if more data has been lost than I am aware of? This
particular table happened to have a hash value in it and when it did not
match up I became aware of the missing records. This also told me where to
look for more missing records. What about tables that don't have a hash
value?
3) How do I protect against lost data in the future?
4) How do I ensure that if there is data loss in the future that I am made
aware of it and can detect where data has been lost?
The database is running on NT4 server, there are about 15 users using it and
it is around 250 megabytes in size. Clients are 98, 2000, XP all running 97
SR2.
records. I checked a backup of the database and the records I suspected
were missing existed in the backup. I am sure its not a logic error because
the table has records inserted into it and there is no code to delete
records or forms bound to the table.
This is obviously alarming and I have the following concerns I would
appreciate any guidance on:
1) How did the data get lost in the first place? The database has required
a number of repairs and I am wondering if the data could have been lost
during a compact/repair. Please note there was no indication of lost data;
i.e., no #error values in table fields, etc. The data has just disappeared.
2) How do I know if more data has been lost than I am aware of? This
particular table happened to have a hash value in it and when it did not
match up I became aware of the missing records. This also told me where to
look for more missing records. What about tables that don't have a hash
value?
3) How do I protect against lost data in the future?
4) How do I ensure that if there is data loss in the future that I am made
aware of it and can detect where data has been lost?
The database is running on NT4 server, there are about 15 users using it and
it is around 250 megabytes in size. Clients are 98, 2000, XP all running 97
SR2.