Bug?

[Al]

Does any one know if there is any bug in Access that makes
some of its tables lose their relationship to one another?
this happend to me couple of times without any reason.
thanks
Al

 

[Allen Browne]

This problem has been reported a few times recently, though I have not seen
it since A95.

Make sure you have the latest service pack for for your version of Access
and also for JET 4. Both are available from the Downloads section of:
http://support.microsoft.com

Also, make sure Name AutoCorrect is turned off. There are many documented
issues where it gets confused between objects, so it is an obvious suspect.
More info:
http://members.iinet.net.au/~allenbrowne/bug-03.html