Disappeared Relationships; Can't Recreate

[MIG]

I don't know what might have caused any corruption; possibly a network
glitch, but several relationships have disappeared from my database,
potentially allowing invalid records to be created.

The relationships have not just disappeared from graphical layout;
they really don't apply when I add records (allowing values not in the
previously linked table).

When I try to recreate the relationships, I can't, and I realise that
what has happened is that the relevant fields are no longer Primary
Keys in the respective tables (and therefore the relationships are not
valid).

However, the error messages when I try to create relationships are
various things, like the field name doesn't exist (nonsense) or that
the table is in use (it isn't).

Other than "Access has no resilience when things go wrong", has anyone
got any idea what has been occurring here?

 

[Tony Toews]

Other than "Access has no resilience when things go wrong", has anyone
got any idea what has been occurring here?

I'd start by importing all the objects into a new database which
should clean things up.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

 

[MIG]

I'd start by importing all the objects into a new database which
should clean things up.

Tony

I have reassigned Primary Keys and recreated the relationships (I hope
I haven't missed any) and it seems to be OK for now. I'll just keep
on making backups so that I can tell when it happens again. The
trouble with something like this is that a lot of relationships were
effectively enforced via combo boxes anyway, so it could have been
like this unnoticed for a long time.