If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Relationship view
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 |
#2
|
|||
|
|||
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) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calendar - 1 Day View | Corey | Calendar | 0 | August 13th, 2004 08:49 PM |
Relationship not showing up in relationship view | Tom | Database Design | 10 | August 10th, 2004 05:01 PM |
sql view | charles osborne | Running & Setting Up Queries | 4 | May 29th, 2004 04:16 PM |
sql view | charles osborne | Using Forms | 1 | May 29th, 2004 05:42 AM |
sql view | charles osborne | Database Design | 1 | May 29th, 2004 05:21 AM |