Relationship tables auto-created?!?

From: nobogustablesplease (anonymous_at_discussions.microsoft.com)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 14:41:05 -0800

I'm designing an Access 2000 database. I have created about 15 tables and
defined relationships among them. 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. They are attached by relationships to another table that
already has a (valid) relationship to the "real" Person table. There are
no such "bogus" tables being created in the Table list, just in the file's
relationships window. I can delete the bogus tables easily, but as soon
as I save and reopen the file they are back again, so that I cannot seem
to permanently get rid of them. I can't find anything in the documentation
talking about automatic creation of relationship tables either.

Relevant Pages

  • Re: Relationship tables auto-created?!?
    ... These bogus table have names ... To get rid of the duplicate relationships, ... not the table icon but the line - and delete it. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Capitalise words?
    ... > If a user wants to put a bogus name, ... > maintaining this database, requires some help from the system it's self. ... I know that Jannie Van ... if you capitalize the words then ...
    (alt.php)
  • fulltext logical files offline and cant be deleted
    ... I have a database with one data file, one log file and 2 bogus, offline ... The physical path for both FT folders is not valid. ... How do i get rid of these bogus DB "files"? ...
    (microsoft.public.sqlserver.fulltext)
  • Re: DataReader Seek
    ... I just emailed you a sample CF app (CAB and source) that loads your database with bogus item data and ...
    (microsoft.public.sqlserver.ce)
  • Strange Problem With Form
    ... mde without giving any problems. ... after I save the form and try to reopen it I get a bogus "out of ... memory error) and still won't open in either view if imported into a ... clean database. ...
    (comp.databases.ms-access)