Can relationships be broken without user interference?

[dawnd3]

This may sound like a silly question, but I want to be sure of things before I assume fowl play. My client has a database where some of the relationships have been deleted between tables and the field boxes in the relationship screen have been "scrunched" down. I knew I would have never left it in such a mess. I confirmed this by looking at my copy of their database on my own computer and everything was perfect. Is there something that can cause this to happen or is it more likely someone went in and deleted some of the relationships? Could something happen during the linking of tables to the front end or moving the database from one spot on the server to another? (Access 2000)

Thanks, Dawn

http://www.calliopeconsulting.net

 

[WildHare]

While I wouldn't stake my bottom dollar (which I happen to have right here..) on it, I'd bet the relationships were broken by human intervention - I have never encountered an "outside" event that corrupted my table relationships as defined - not counting deliberate programming alterations, of course.

Especially if the table boxes are re-sized from what you have,then almost always to me would mean that someone went in there, mucked about either knowingly or stupidly, and then "saved" the changes when the relationships window was closed.

Jim Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm