Lost relationships & primary keys

[myhnews]

On July 2008 I lost the joins/relationships between many tables as well as some primary keys? This allowed the user to enter the same value in the primary key field.

I manually removed all duplications and fixed all relationships and primary keys.

Recently the users called me again that they see duplicated records. I checked the BE and I see that the BE lost relationships & primary keys again.

Does anyone know why this is happening? and how to prevent this from happening again

Access 2003
There are 67 tables; 10-15 are small lookup tables.
Total records (all tables) about 230,000
BE size = 37 MB
Primary keys are auto numbers and is hidden from the uses
DB has FE/BE
Users do not have BE access only forms, not even to query design
Maybe total 10-15 memo fields

Thanks

 

[jdraw]

On July 2008 I lost the joins/relationships between many tables as well as some primary keys? This allowed the user to enter the same value in the primary key field.

I manually removed all duplications and fixed all relationships and primary keys.

Recently the users called me again that they see duplicated records. I checked the BE and I see that the BE lost relationships & primary keys again.

Does anyone know why this is happening? and how to prevent this from happening again

Access 2003
There are 67 tables; 10-15 are small lookup tables.
Total records (all tables) about 230,000
BE size = 37 MB
Primary keys are auto numbers and is hidden from the uses
DB has FE/BE
Users do not have BE access only forms, not even to query design
Maybe total 10-15 memo fields

Thanks

Are you saying that something destroyed the Indexes and relationships in BE in July 2008 and again early in 2009 - twice in about 8 months?
How long has the database been running?

Is it possible someone (or some automated backup/archiving process) installed a copy of the database from an older version. Or moved the database to a different location?

Somehow the links must have been deleted. I think this could happen if the database was on one drive then moved to a different drive without relinking the tables.

You could record where the backend tables physically exist, and see if there's a change in location should the problem happen again.

Just some thoughts.

 

[neileg]

Access 2003 is a bit buggy. If you have installed all 3 service packs, have you also applied the hotfix that corrects the bugs in SP3?