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