What happened to the table relationships in my database

[mahenkj2]

In my database, I had around 20 tables with defined relationships. It was working fine, but just today during working I saw that there was no relationship showing at all in RL window. What may have happened.

Anyway, I always keep making copy, so may be not so much lost but still If someone can help to find out the probable cause to take care of.

best regards.

 

[VilaRestal]

In the RL window right click and select Show All.

Do the relationships appear?

If not, that's a new one. I've never had a database lose its relationships.

 

[mahenkj2]

I did that but no effect. also, it seems dB is working fine, although I have checked thoroughly.

 

[VilaRestal]

Maybe try:

Take a copy of the database, delete all the tables from it (it would be interesting to note whether access complains that any table is part of a relationship when you do).

Import all the tables with relationships from the original.

 

[mahenkj2]

I tried it in front end. It just gave alert that by deleting you will just delete a link not the table it self and on agreeing it deleted the link. Later, I made a copy of back end and deleted a table, then it gave alert that by deleting this table, you will remove it from groups. Nowhere, it alarmed that the tables are in some relationship.

 

[VilaRestal]

That is very strange.

It certainly sounds like the relationships have gone.

Of course I've known databases become corrupt so that certain records can't be read, or certain tables can't be opened, or the database itself can't be opened, but I've never known a database lose a relationship. Let alone all of them.

I take it we can rule out a human cause (sabotage perhaps).

 

[RainLover]

I have seen this.

Your relationships are still there they have just gone off screen.

Have you checked your scroll bars?

You can most likely Tab from one table to the other. You can even delete that table from your relationships even though they are still hidden.

Finally if you use show all tables you get everything back

 

[VilaRestal]

Finally if you use show all tables you get everything back

That was the first thing suggested.

As you can see deleting the tables doesn't warn about deleting a relationship. If everything is as described the relationships have gone.

 

[RainLover]

I wonder if there is a misunderstanding.

I think you meant to delete the actual tables.

I meant to delete the tables in the relationship window. Even though you can't see them you can Tab to them and hit delete. Then hit show all tables.

Are we singing the same song?

 

[VilaRestal]

But deleting the tables (from a copy), not from the relationship window but really deleting them, will test whether there is indeed any relationships: access will warn about deleting relationships ("must delete relationships first").

#5 says to me that there are no relationships.

 

[RainLover]

OK.

But If you don't think what I suggested earlier will work, then delete from the FE and relink.

Or are the Relationships missing from the Back End. Or even worse were they created in the front end not the back end.

I guess we need to hear from the OP.

 

[VilaRestal]

Or are the Relationships missing from the Back End.

It certainly seems that way.

Or even worse were they created in the front end not the back end.

But that would explain it.

I guess we need to hear from the OP.

Agreed.

 

[Pat Hartman]

Relationships are defined in the BE and managed there. They don't always show in the FE so which database do you have open? The FE or the BE?

 

[mahenkj2]

My all relationships were created before splitting the database. After split, I have made some cosmetic changes to front end and while working I noticed in RL window that there were no joining lines between tables. All tables which I used were available.

Then I opened my last copy, and all relations were present.

Then I opened backend, in RL window there were no tables. If I press show table, then it was allowing to add tables.

@Rain
I know if we hide table from RL window the relation remain there and show all presents all tables. But my all tables are already there.

I hope I could present the info required.

best regards.

 

[RainLover]

Did you use the wizard to split the database or did you export the Tables to a blank Database or something completely different.

 

[mahenkj2]

I used the wizard. Then for distribution, I usually make accde. I hope it is a standard practice.

best regards.

 

[RainLover]

Yep

Standard practice.

Just trying to understand the cause of the problem.

Don't think I can.