Huge Relationship Problems

  • Thread starter Thread starter NeverSeenBlue
  • Start date Start date
N

NeverSeenBlue

My database mysteriously changed the relationships between tables in m
query so that instead of all the tables being linked to the one mai
table, they instead are also linked to each other. This basically i
causing the whole database to crash and whenever I try to fix it i
goes right back to that incorrect format. PLEASE HELP
 
So do you actually go in and delete the relationships and they then
re-appear?

Try importing all objects into a new file, and re-set the relationships.

Sounds strange though!!
 
NeverSeenBlue said:
My database mysteriously changed the relationships between tables in my
query so that instead of all the tables being linked to the one main
table, they instead are also linked to each other. This basically is
causing the whole database to crash and whenever I try to fix it it
goes right back to that incorrect format. PLEASE HELP.
Click to expand...

In a query? In may be that your fields are named the same between
tables. Thus the query manager assumes these fields are related.

What do you mean by crashing?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
BOOST - Can someone please help me. This is for something for my wor
that I've been working on since December 2002 and now it's all messe
up and I'm about to have a panic attack. Thank you
 
NeverSeenBlue said:
BOOST - Can someone please help me. This is for something for my work
that I've been working on since December 2002 and now it's all messed
up and I'm about to have a panic attack. Thank you.
Click to expand...

Did you see the posting I made 2.5 hours before your posting?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
BOOST - Can someone please help me. This is for something for my work
that I've been working on since December 2002 and now it's all messed
up and I'm about to have a panic attack. Thank you.
Click to expand...

Could you please explain? I didn't see any prior discussion on this
subject, and there is no way to provide any meaningful advice unless
we can see what problem you're having!
 
I have just experience similar problems. All of a sudden most of my relationships have disappeared. I try recreating & saving new relationships but after closing the relationship window and reopening it, the relationships are gone & are not saved at all

If anyone can help me with this problem, it would be much appreciated. (Using Access 2002)
 
I have just experience similar problems. All of a sudden most of my relationships have disappeared. I try recreating & saving new relationships but after closing the relationship window and reopening it, the relationships are gone & are not saved at all.

If anyone can help me with this problem, it would be much appreciated. (Using Access 2002)
Click to expand...

I suspect that the *relationships* are still there - it's just the
*graphical display* that's messed up.

Try running this VBA code. Create a new Module; copy and paste this
code into it; then in the Immediate window type

ShowAllRelations

Sub ShowAllRelations()
Dim db As DAO.Database
Dim rel As Relation
Dim fld As Field
Set db = CurrentDb
For Each rel In db.Relations
Debug.Print "Relation "; rel.Name, rel.Table, _
rel.ForeignTable, Hex(rel.Attributes)
For Each fld In rel.Fields
Debug.Print fld.Name; " linked to "; fld.ForeignName
Next fld
Next rel
End Sub
 
Back
Top