View Single Post
  #2  
Old August 24th, 2004, 08:07 PM
John Vinson
external usenet poster
 
Posts: n/a
Default

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

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


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)