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!