Access 2003 relationships disappear

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

cgable

Thread Starter
Joined
Mar 31, 2010
Messages
1
I have a large Access 2003 database that I have been modifying and updating. Every table is linked and every table is related to every other table. This has worked perfectly for all the tables except one. It seems to be linked if you ask it to show direct links, but if you close the relationships window (after saving) and reopen, the relationships are no longer visible.
Also, when i asked it to show direct relationships, 3 copies of the table were created, linked to random other tables. I deleted the links and the copies of the tables, and they have no come back, but it seems odd for them to have been created in the first place. Please let me know if you have any suggestions. Thanks!
 

OBP

Joined
Mar 8, 2005
Messages
19,896
cgable, welcome to the Forum.
Sometimes when you add a table to the Relationships Access tries to establish the relationship to other tables with the same Key field name (Like ID for instance). If the table is not visible and you add it again that is probably why you had 3 of them.
Have you used used the "Show All Relationships" menu Icon to check that the table is there?
The othe rpoint of interest is where are you establishing the relationships, in the Front or the Backend (where the tables are) of the database?
Normally you would create them in the Backend.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top