Relationships not displaying

[Dave]

I have sifited through the numerous posts on this topic, however, I have not had any sucess wit
any of the solutions posted to other simliar problems. I can not view the relationships built betwee
my tables. I have tried the obvious "show all relationships" as well as "show direct" and none appea
(dispalyed when created,however). I am not running linked tables, nor did I make copies of tables
with exsisting relationships

I tried a collegue's machine that is running WIN XP and all of the realtionships pulled up just fine
Is there something that my Access load for WIN2000 may be missing or some DLL that needs to be re-installed

 

[John Vinson]

I tried a collegue's machine that is running WIN XP and all of the realtionships pulled up just fine.
Is there something that my Access load for WIN2000 may be missing or some DLL that needs to be re-installed?

In my experience the Relationships window has never been very
reliable. Relationships unpredictably disappear from view, and
sometimes can be recovered and sometimes cannot; sometimes they move
*off the edge of the screen* - they exist but aren't visible.

Some things to try:

MAKE A BACKUP OF YOUR DATABASE and do these on a copy!

- Use the Clear button to blank the relationships screen altogether,
and then View All.

- Or, use Clear; add one table and select View Direct; select each
branch off this table and View Direct again and so on.

- Use this small tactical nuclear device to explicitly remove all
relationships from your database and rebuild them from scratch:

Sub KillAllRelations()
Dim db As DAO.Database
Dim rel As Relation
Dim inti As Integer
Set db = DBEngine(0)(0)
For inti = db.Relations.Count - 1 To 0 Step -1
Set rel = db.Relations(inti)
Debug.Print "Deleting relation "; rel.Name, rel.Table, _
rel.ForeignTable
db.Relations.Delete rel.Name
Next inti
End Sub