A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Not seeing all relationships in layout window



 
 
Thread Tools Display Modes
  #1  
Old June 18th, 2004, 03:41 PM
jettabug
external usenet poster
 
Posts: n/a
Default 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  
Old June 18th, 2004, 04:19 PM
Allen Browne
external usenet poster
 
Posts: n/a
Default 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  
Old June 18th, 2004, 04:47 PM
jettabug
external usenet poster
 
Posts: n/a
Default 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  
Old June 18th, 2004, 05:42 PM
Allen Browne
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:05 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.