Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Deleting Relationships

Discussion in 'Information Technology' started by Dawn, Nov 4, 2005.

  1. Dawn

    Dawn
    Expand Collapse
    Guest

    I have deleted all relationships, but when I try to change the data type for
    a field in a table, it tells me that a relationship still exists. How do I
    find hidden relationships?

    Thanks,
    --
    Dawn
     
  2. Loading...


  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    You can delete hidden relationships programmatically:
    http://allenbrowne.com/DelRel.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.

    "Dawn" <Dawn@discussions.microsoft.com> wrote in message
    news:933E4F6A-235F-419A-ABA0-14CF91F15AFC@microsoft.com...
    >I have deleted all relationships, but when I try to change the data type
    >for
    > a field in a table, it tells me that a relationship still exists. How do
    > I
    > find hidden relationships?
    >
    > Thanks,
    > --
    > Dawn
     
  4. Aaron

    Aaron
    Expand Collapse
    Guest

    On the relationships screen, right click and "select all".
    There are probably relationships built into your queries.


    "Dawn" wrote:

    > I have deleted all relationships, but when I try to change the data type for
    > a field in a table, it tells me that a relationship still exists. How do I
    > find hidden relationships?
    >
    > Thanks,
    > --
    > Dawn
     
  5. Dawn

    Dawn
    Expand Collapse
    Guest

    i did this and it brings up 2 tables - but no relationship lines - they seem
    to be hidden. Any ideas?
    --
    Dawn


    "Aaron" wrote:

    > On the relationships screen, right click and "select all".
    > There are probably relationships built into your queries.
    >
    >
    > "Dawn" wrote:
    >
    > > I have deleted all relationships, but when I try to change the data type for
    > > a field in a table, it tells me that a relationship still exists. How do I
    > > find hidden relationships?
    > >
    > > Thanks,
    > > --
    > > Dawn
     

Share This Page