Relationship not showing up in relationship view

Hi,

I am using Access 2000, and had a relationship setup to link 2 tables
together. I later decided to change the design and delete the link. The link
is not showing up in "Relationhips" view, and when I try to add a record it
says I can't because the record doesn't exist in the related table. It says
to break the link before I can change, but I can't because it doesn't show
up. HELP

Thanks,

Tom
--
When eveythings coming at you at once, you're in the wrong lane.

try opening the Relationships window and clicking the Show All Relationships
button on the toolbar.

hth


"Tom" wrote in message
...
Hi,

I am using Access 2000, and had a relationship setup to link 2 tables
together. I later decided to change the design and delete the link. The
link
is not showing up in "Relationhips" view, and when I try to add a record
it
says I can't because the record doesn't exist in the related table. It
says
to break the link before I can change, but I can't because it doesn't show
up. HELP

Thanks,

Tom
--
When eveythings coming at you at once, you're in the wrong lane.

Hi Tina,

I have, but it doesn't show any relationships for the table in
question. I even created a new relationship for the same table, and then
saved it. When I went back to relationships, it wasn't there. Any ideas?

Thanks,

Tom

"tina" wrote:

try opening the Relationships window and clicking the Show All Relationships
button on the toolbar.

hth


"Tom" wrote in message
...
Hi,

I am using Access 2000, and had a relationship setup to link 2 tables
together. I later decided to change the design and delete the link. The
link
is not showing up in "Relationhips" view, and when I try to add a record
it
says I can't because the record doesn't exist in the related table. It
says
to break the link before I can change, but I can't because it doesn't show
up. HELP

Thanks,

Tom
--
When eveythings coming at you at once, you're in the wrong lane.

hmm, sorry, no. hopefully the "not resolved" in the subject line will catch
others' attention and get you more help. if you don't get another response
in a day or so, suggest you post the question again to a new thread.
also, suggest you don't respond to this post, as others may think it's being
handled, and not take the time to look at it. good luck!


"Tom" wrote in message
...
Hi Tina,

I have, but it doesn't show any relationships for the table in
question. I even created a new relationship for the same table, and then
saved it. When I went back to relationships, it wasn't there. Any ideas?

Thanks,

Tom

"tina" wrote:

try opening the Relationships window and clicking the Show All
Relationships
button on the toolbar.

hth


"Tom" wrote in message
...
Hi,

I am using Access 2000, and had a relationship setup to link 2
tables
together. I later decided to change the design and delete the link.
The
link
is not showing up in "Relationhips" view, and when I try to add a
record
it
says I can't because the record doesn't exist in the related table. It
says
to break the link before I can change, but I can't because it doesn't
show
up. HELP

Thanks,

Tom
--
When eveythings coming at you at once, you're in the wrong lane.

Try deleting the table itself from the Relationships window (it isn't
actually deleted from the database, just from the display), and then click
Show All Tables.

--

Ken Snell
MS ACCESS MVP

"tina" wrote in message
...
hmm, sorry, no. hopefully the "not resolved" in the subject line will
catch
others' attention and get you more help. if you don't get another response
in a day or so, suggest you post the question again to a new thread.
also, suggest you don't respond to this post, as others may think it's
being
handled, and not take the time to look at it. good luck!


"Tom" wrote in message
...
Hi Tina,

I have, but it doesn't show any relationships for the table in
question. I even created a new relationship for the same table, and then
saved it. When I went back to relationships, it wasn't there. Any ideas?

Thanks,

Tom

"tina" wrote:

try opening the Relationships window and clicking the Show All
Relationships
button on the toolbar.

hth


"Tom" wrote in message
...
Hi,

I am using Access 2000, and had a relationship setup to link 2
tables
together. I later decided to change the design and delete the link.
The
link
is not showing up in "Relationhips" view, and when I try to add a
record
it
says I can't because the record doesn't exist in the related table.
It
says
to break the link before I can change, but I can't because it
doesn't
show
up. HELP

Thanks,

Tom
--
When eveythings coming at you at once, you're in the wrong lane.

Tom, it sounds like Access is enforing a relation that you cannot see, and
it does not even show up when you "Show All".

You can programmatically list the relations using the code below, and you
can also use the Delete method of the Relations collection to get rid of a
hidden relation once you know its name. If you are comfortable with code,
that might be the way to go.

Function ShowRel()
'Purpose: List the relations to the Immediate Window.
Dim db As DAO.Database
Dim rel As DAO.Relation

Set db = DBEngine(0)(0)
For Each rel In db.Relations
Debug.Print rel.Name, rel.Table, rel.ForeignTable
Next

Set rel = Nothing
Set db = Nothing
End Function

If you are still stuck, the code in this link deletes ALL the relationship
in your database. After compacting, you can then rebuild the ones you want:
http://members.iinet.net.au/~allenbrowne/DelRel.html

The most likely cause for the problem is Name Autocorrect. Uncheck the boxes
under Tools | Options | General | Name AutoCorrect, and then compact the
database so the problem does not recur. More information about these
problems:
http://members.iinet.net.au/~allenbrowne/bug-03.html

As a last resort, you can always get Access to rebuild your database by
creating a new one (File | New) and importing everything from the problem
one (File | Get External | Import). In that dialog there is an Options
button, which allows you to NOT import the relations.

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

"Tom" wrote in message
...

I am using Access 2000, and had a relationship setup to link 2 tables
together. I later decided to change the design and delete the link. The
link
is not showing up in "Relationhips" view, and when I try to add a record
it
says I can't because the record doesn't exist in the related table. It
says
to break the link before I can change, but I can't because it doesn't show
up. HELP

Thanks,

Tom
--
When eveythings coming at you at once, you're in the wrong lane.

I am having the exact same problem and none of the
solutions seem to work. Suggested code for deleting
relationships shows a compile error. Hard to believe this
problem is happening in an established product like
Access. If anyone finds a solution please let me know.
Have to redefine the DB due to this.
-----Original Message-----
Hi,

I am using Access 2000, and had a relationship setup
to link 2 tables
together. I later decided to change the design and
delete the link. The link
is not showing up in "Relationhips" view, and when I try
to add a record it
says I can't because the record doesn't exist in the
related table. It says
to break the link before I can change, but I can't
because it doesn't show
up. HELP

Thanks,

Tom
--
When eveythings coming at you at once, you're in the
wrong lane.
.

If the code will not compile, you probably need to add a reference to the
DAO library.

1. Open the code window.
2. Choose References on the Tools menu.
3. Check the box beside:
Microsoft DAO 3.6 Library.

More information:
http://members.iinet.net.au/~allenbrowne/ser-38.html

I have not personally seen this problem for 7 years, but we always make sure
that Name AutoCorrect is turned off. It would be the primary suspect for
this corruption. More reasons why it should be turned off:
http://members.iinet.net.au/~allenbrowne/bug-03.html

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

"Bob" wrote in message
...
I am having the exact same problem and none of the
solutions seem to work. Suggested code for deleting
relationships shows a compile error. Hard to believe this
problem is happening in an established product like
Access. If anyone finds a solution please let me know.
Have to redefine the DB due to this.
-----Original Message-----
Hi,

I am using Access 2000, and had a relationship setup
to link 2 tables
together. I later decided to change the design and
delete the link. The link
is not showing up in "Relationhips" view, and when I try
to add a record it
says I can't because the record doesn't exist in the
related table. It says
to break the link before I can change, but I can't
because it doesn't show
up. HELP

Thanks,

Tom
--
When eveythings coming at you at once, you're in the
wrong lane.
.

Hi Allen,

How do I run this code? Do I create a .vbs file with it? And
after, how do I delete these relationships once I see them. Is there an
option for that?

Thanks,

Tom

"Allen Browne" wrote:

Tom, it sounds like Access is enforing a relation that you cannot see, and
it does not even show up when you "Show All".

You can programmatically list the relations using the code below, and you
can also use the Delete method of the Relations collection to get rid of a
hidden relation once you know its name. If you are comfortable with code,
that might be the way to go.

Function ShowRel()
'Purpose: List the relations to the Immediate Window.
Dim db As DAO.Database
Dim rel As DAO.Relation

Set db = DBEngine(0)(0)
For Each rel In db.Relations
Debug.Print rel.Name, rel.Table, rel.ForeignTable
Next

Set rel = Nothing
Set db = Nothing
End Function

If you are still stuck, the code in this link deletes ALL the relationship
in your database. After compacting, you can then rebuild the ones you want:
http://members.iinet.net.au/~allenbrowne/DelRel.html

The most likely cause for the problem is Name Autocorrect. Uncheck the boxes
under Tools | Options | General | Name AutoCorrect, and then compact the
database so the problem does not recur. More information about these
problems:
http://members.iinet.net.au/~allenbrowne/bug-03.html

As a last resort, you can always get Access to rebuild your database by
creating a new one (File | New) and importing everything from the problem
one (File | Get External | Import). In that dialog there is an Options
button, which allows you to NOT import the relations.

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

"Tom" wrote in message
...

I am using Access 2000, and had a relationship setup to link 2 tables
together. I later decided to change the design and delete the link. The
link
is not showing up in "Relationhips" view, and when I try to add a record
it
says I can't because the record doesn't exist in the related table. It
says
to break the link before I can change, but I can't because it doesn't show
up. HELP

Thanks,

Tom
--
When eveythings coming at you at once, you're in the wrong lane.

To use the code:
1. Select the Modules tab of the Database Window.

2. Click New. Access opens a code window.

3. Paste the function into this code window.

4. If Access 2000 or 2002, choose References from the Tools menu, and check
the box beside:
Microsoft DAO 3.6 Library.

5. Choose Compile from the Debug menu. (This checks Access can make sense of
the code.)

6. Press Ctrl+G to open the Immediate Window. Enter:
? ShowRel()

Once you know the name of the relation you want to delete, you can enter
this directly into the Immediate Window:
dbEngine(0)(0).Relations.Delete "xxxxx"
where "xxxxx" represents the name of the relation you want to get rid of.

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

"Tom" wrote in message
...
Hi Allen,

How do I run this code? Do I create a .vbs file with it? And
after, how do I delete these relationships once I see them. Is there an
option for that?

Thanks,

Tom

"Allen Browne" wrote:

Tom, it sounds like Access is enforing a relation that you cannot see,
and
it does not even show up when you "Show All".

You can programmatically list the relations using the code below, and you
can also use the Delete method of the Relations collection to get rid of
a
hidden relation once you know its name. If you are comfortable with code,
that might be the way to go.

Function ShowRel()
'Purpose: List the relations to the Immediate Window.
Dim db As DAO.Database
Dim rel As DAO.Relation

Set db = DBEngine(0)(0)
For Each rel In db.Relations
Debug.Print rel.Name, rel.Table, rel.ForeignTable
Next

Set rel = Nothing
Set db = Nothing
End Function

If you are still stuck, the code in this link deletes ALL the
relationship
in your database. After compacting, you can then rebuild the ones you
want:
http://members.iinet.net.au/~allenbrowne/DelRel.html

The most likely cause for the problem is Name Autocorrect. Uncheck the
boxes
under Tools | Options | General | Name AutoCorrect, and then compact the
database so the problem does not recur. More information about these
problems:
http://members.iinet.net.au/~allenbrowne/bug-03.html

As a last resort, you can always get Access to rebuild your database by
creating a new one (File | New) and importing everything from the problem
one (File | Get External | Import). In that dialog there is an Options
button, which allows you to NOT import the relations.


"Tom" wrote in message
...

I am using Access 2000, and had a relationship setup to link 2 tables
together. I later decided to change the design and delete the link. The
link
is not showing up in "Relationhips" view, and when I try to add a
record
it
says I can't because the record doesn't exist in the related table. It
says
to break the link before I can change, but I can't because it doesn't
show
up. HELP

Thanks,

Tom
--
When eveythings coming at you at once, you're in the wrong lane.