Relationship tables auto-created?!?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm designing an Access 2000 database. I have created about 15 tables an
defined relationships among them. When I save the file and then open i
back up again and go to the relationship window, I find to my dismay tha
Access has automagically created some bogus tables in the relationshi
window, complete with relationship links. These bogus table have name
identical to "real" tables, except that they have a suffix of the form "_n
where n is the number of the bogus table. For example, if the "real
table is "Person" then the bogus tables will be "Person_1", "Person_2"
and so on. They are attached by relationships to another table tha
already has a (valid) relationship to the "real" Person table. There ar
no such "bogus" tables being created in the Table list, just in the file'
relationships window. I can delete the bogus tables easily, but as soo
as I save and reopen the file they are back again, so that I cannot see
to permanently get rid of them. I can't find anything in the documentatio
talking about automatic creation of relationship tables either.
 
When I save the file and then open it
back up again and go to the relationship window, I find to my dismay that
Access has automagically created some bogus tables in the relationship
window, complete with relationship links. These bogus table have names
identical to "real" tables, except that they have a suffix of the form "_n"
where n is the number of the bogus table. For example, if the "real"
table is "Person" then the bogus tables will be "Person_1", "Person_2",
and so on.
Click to expand...

This phenomenon arises when there are two or more relationships
defined between the same pair of tables. One common way that this
happens is due to the use of the "Lookup Wizard" - this abominable
misfeature creates a new relationship between the table and the lookup
table, even if such a relationship already exists.

To get rid of the duplicate relationships, select the *join line* -
not the table icon but the line - and delete it. You'll then be able
to delete the icon and it will stay gone. Be sure you get rid of all
the redundant relationships; they add disk space, slow updates, and do
no good at all.
 
Back
Top