Re: Relationship tables auto-created?!?

• Previous message: Lindac9683: "Access Build Event to print form letter"
• In reply to: nobogustablesplease: "Relationship tables auto-created?!?"
• Messages sorted by: [ date ] [ thread ]

Date: Thu, 18 Mar 2004 18:53:35 -0700

On Thu, 18 Mar 2004 14:41:05 -0800, "nobogustablesplease"
<anonymous@discussions.microsoft.com> wrote:

>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.

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.

                  John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

• Previous message: Lindac9683: "Access Build Event to print form letter"
• In reply to: nobogustablesplease: "Relationship tables auto-created?!?"
• Messages sorted by: [ date ] [ thread ]