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
|
|||
|
|||
Not seeing all relationships in layout window
I am using Access 2003 (200 file format) and trying to delete a primary key. I am told by the system that this field is part of one or more relationships... to delete the relationship in the relationships windows.
I go to the relationship layout window, choose "show all" and no relationships show up at all. Yet, when I choose each individual table, and tell it to "show direct", I get just direct connections for that table. My first question is why doesn't the direct relationships show up when I choose "show all" and how can I make them appear so that I can delete the ones I can't see? Thanks, Robin |
#2
|
|||
|
|||
Not seeing all relationships in layout window
Hi Robin
Sounds like your project is partially corrupt. 1. Repair your database: Tools | Database Utilities | Compact/Repair 2. Go to http://support.microsoft.com, click on Downloads, and download and install: Service Pack 8 for JET 4. 3. Create a new (blank) database: File | New. 4. Immediately uncheck the boxes under: Tools | Options | AutoCorrect. This feature causes many corruptions: http://allenbrowne.com/bug-03.html 5. Import all the objects from your existing database: File | Get External | Import This forces Access to recreate the database objects, using the latest version of JET, and without tracking old changes to the field names. You should now be able to open the Relationships window, click Show All, and rearrange your tables as desired. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "jettabug" wrote in message ... I am using Access 2003 (200 file format) and trying to delete a primary key. I am told by the system that this field is part of one or more relationships... to delete the relationship in the relationships windows. I go to the relationship layout window, choose "show all" and no relationships show up at all. Yet, when I choose each individual table, and tell it to "show direct", I get just direct connections for that table. My first question is why doesn't the direct relationships show up when I choose "show all" and how can I make them appear so that I can delete the ones I can't see? Thanks, Robin |
#3
|
|||
|
|||
Not seeing all relationships in layout window
Allen, Thanks for responding.
I have done what you suggested but it did not solve the problem. The new database still does the same thing in the relationships window. "Allen Browne" wrote: Hi Robin Sounds like your project is partially corrupt. 1. Repair your database: Tools | Database Utilities | Compact/Repair 2. Go to http://support.microsoft.com, click on Downloads, and download and install: Service Pack 8 for JET 4. 3. Create a new (blank) database: File | New. 4. Immediately uncheck the boxes under: Tools | Options | AutoCorrect. This feature causes many corruptions: http://allenbrowne.com/bug-03.html 5. Import all the objects from your existing database: File | Get External | Import This forces Access to recreate the database objects, using the latest version of JET, and without tracking old changes to the field names. You should now be able to open the Relationships window, click Show All, and rearrange your tables as desired. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "jettabug" wrote in message ... I am using Access 2003 (200 file format) and trying to delete a primary key. I am told by the system that this field is part of one or more relationships... to delete the relationship in the relationships windows. I go to the relationship layout window, choose "show all" and no relationships show up at all. Yet, when I choose each individual table, and tell it to "show direct", I get just direct connections for that table. My first question is why doesn't the direct relationships show up when I choose "show all" and how can I make them appear so that I can delete the ones I can't see? Thanks, Robin |
#4
|
|||
|
|||
Not seeing all relationships in layout window
Make a *copy* of your database, and run this code to programmatically delete
all relationships in your database, even the hidden ones: http://allenbrowne.com/DelRel.html Then compact the database, and see if you can build them from scratch. We used to need to do this back in the Access 95 days, but have not seen this recently. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "jettabug" wrote in message ... Allen, Thanks for responding. I have done what you suggested but it did not solve the problem. The new database still does the same thing in the relationships window. "Allen Browne" wrote: Hi Robin Sounds like your project is partially corrupt. 1. Repair your database: Tools | Database Utilities | Compact/Repair 2. Go to http://support.microsoft.com, click on Downloads, and download and install: Service Pack 8 for JET 4. 3. Create a new (blank) database: File | New. 4. Immediately uncheck the boxes under: Tools | Options | AutoCorrect. This feature causes many corruptions: http://allenbrowne.com/bug-03.html 5. Import all the objects from your existing database: File | Get External | Import This forces Access to recreate the database objects, using the latest version of JET, and without tracking old changes to the field names. You should now be able to open the Relationships window, click Show All, and rearrange your tables as desired. "jettabug" wrote in message ... I am using Access 2003 (200 file format) and trying to delete a primary key. I am told by the system that this field is part of one or more relationships... to delete the relationship in the relationships windows. I go to the relationship layout window, choose "show all" and no relationships show up at all. Yet, when I choose each individual table, and tell it to "show direct", I get just direct connections for that table. My first question is why doesn't the direct relationships show up when I choose "show all" and how can I make them appear so that I can delete the ones I can't see? Thanks, Robin |
Thread Tools | |
Display Modes | |
|
|