Relationships in Access 2002

  • Thread starter Thread starter Earl
  • Start date Start date
E

Earl

The relationship in our db are randomly dropped. It
doesn't happen all the time or with all users. What do we
need to consider to find and fix this problem?
 
Probably another Name AutoCorrect bug. Uncheck the boxes under:
Tools | General | Name AutoCorrect
and then compact the database.
If the database is split, do that for both the front end and the back end.

For an explanation of how this misfeature corrupts your database and a list
of the problems it creates, see:
http://members.iinet.net.au/~allenbrowne/bug-03.html
Basically, it tries to track changes in field names. When it stuffs that up,
it can no longer identify which fields are related to which other fields.

If is is too badly corrupted to be fixed by the above, try the 6 steps under
the first symptom in:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html
 
Back
Top