Imported Tables and Relationships not shown in Relationships form

[John Google]

Hi,

Access 2002.

I import tables from another database where I only copy the definition
and not the data.

I select the Import Relationships option on the import dialog. After I
do the import the empty tables are there with the correct defintion
and the MSysRelationshi ps table is updated with the relationships
between the imported tables.

However, when I go to Tools / Relationships it only shows the
relationships between tables which were there before the import. Is
this a bug? How do I get the Tools / Relationships window to show the
real information?

[Chris O'C via AccessMonster.com]

Re: Imported Tables and Relationships not shown in Relationships form

Right click in the relationships window and select "show all."

Chris
Microsoft MVP


John Google wrote:

>Hi,
>
>However, when I go to Tools / Relationships it only shows the
>relationship s between tables which were there before the import. Is
>this a bug? How do I get the Tools / Relationships window to show the
>real information?

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200804/1

[John Google]

Re: Imported Tables and Relationships not shown in Relationships form

On 17 Apr, 20:09, "Chris O'C via AccessMonster.c om" <u29189@uwe>
wrote:

Right click in the relationships window and select "show all."
>
Chris
Microsoft MVP
>

Excellent!

Thanks Chris.