Relationships in Access 2002

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?
 
A

Allen Browne

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top