Not seeing all relationships in layout window

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.

Reply to group, rather than allenbrowne at mvps dot org.

jettabug said:
I am using Access 2003 (200 file format) and trying to delete a primary
Click to expand...
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
Click to expand...
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
Click to expand...
choose "show all" and how can I make them appear so that I can delete the
ones I can't see?
 
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.
 
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.

Reply to group, rather than allenbrowne at mvps dot org.

jettabug said:
Allen, Thanks for responding.

I have done what you suggested but it did not solve the problem. The
Click to expand...
new database still does the same thing in the relationships window.
 
Back
Top