Relationship view

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

- 24 Aug 2004 19:01 GMT

Hello,

I have been working on a database(new to access) so in the
process i have been deleteing and creating tables.When i
go into RELATIONSHIPS and show all....a maze of tables
with connecting lines appear even though i thought they
were deleted.Does this affect my current working tables?
Please advise

Reply to this Message

John Vinson - 24 Aug 2004 20:07 GMT

On Tue, 24 Aug 2004 11:01:47 -0700,

>Hello,
>
[quoted text clipped - 4 lines]
>were deleted.Does this affect my current working tables?
>Please advise

Yes, it does.

To delete a relationship in the relationships window you need to
select the JOIN LINE - not the table icon, but the line connecting
them. Only after deleting the relationship can you delete the table
icon.

You may want to use Tools... Database Utilities... Compact and Repair
Database to recover waste space (and garbage) that Access hasn't
cleaned up.

John W. Vinson[MVP]
(no longer chatting for now)

Reply to this Message