Welcome to SPN

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

Sign Up Now!

Relationship missing

Discussion in 'Information Technology' started by mattc66 via AccessMonster.com, Jul 28, 2006.

  1. mattc66 via AccessMonster.com

    Guest

    What can cause a relationship to be missing.

    I had a relationship setup between two tables. It had been working fine.
    However today I had users complaining about dtatbase issue. When I looked at
    the relationships I found that the link was missing.

    What can cause this issue?

    Matt

    --
    Matt Campbell
    mattc (at) saunatec [dot] com

    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access/200606/1
     
  2. Loading...

    Similar Threads Forum Date
    Relationship with Creator Blogs Oct 17, 2015
    I'm open-minded about romantic relationships... how do I explain to family? Love & Marriage Aug 22, 2015
    Arts/Society What are your thoughts on the interaction of male / female relationship of marriage? Language, Arts & Culture Oct 15, 2013
    Relationship advice Love & Marriage Sep 30, 2012
    Need advice...Sikhi in relationships Love & Marriage Nov 17, 2011

  3. Graham Mandeno

    Graham Mandeno
    Expand Collapse
    Guest

    Hi Matt

    A relationship may be deleted either through the UI (the relationships
    window) or through code.

    I have never known a relationship to just "disappear", although it's
    conceivable that it could happen if a database became corrupted. Have you
    tried compacting and repairing the database?
    --
    Good Luck!

    Graham Mandeno [Access MVP]
    Auckland, New Zealand

    "mattc66 via AccessMonster.com" <u16013@uwe> wrote in message
    news:6212401e18c53@uwe...
    > What can cause a relationship to be missing.
    >
    > I had a relationship setup between two tables. It had been working fine.
    > However today I had users complaining about dtatbase issue. When I looked
    > at
    > the relationships I found that the link was missing.
    >
    > What can cause this issue?
    >
    > Matt
    >
    > --
    > Matt Campbell
    > mattc (at) saunatec [dot] com
    >
    > Message posted via AccessMonster.com
    > http://www.accessmonster.com/Uwe/Forums.aspx/access/200606/1
     
  4. dbahooker@hotmail.com

    dbahooker@hotmail.com
    Expand Collapse
    Guest

    I would reccomend using SQL Server instead of MDB.

    a) it doesnt just randomly get corrupted
    b) it is easy to script RI so that you can enforce it on a scheduled
    basis

    SQL just has much easier version control than MDB.

    these days; you can put DDL triggers to table; so that if anyone
    changes ANYTHING in a table you can rollback changes; etc

    -Aaron



    Graham Mandeno wrote:
    > Hi Matt
    >
    > A relationship may be deleted either through the UI (the relationships
    > window) or through code.
    >
    > I have never known a relationship to just "disappear", although it's
    > conceivable that it could happen if a database became corrupted. Have you
    > tried compacting and repairing the database?
    > --
    > Good Luck!
    >
    > Graham Mandeno [Access MVP]
    > Auckland, New Zealand
    >
    > "mattc66 via AccessMonster.com" <u16013@uwe> wrote in message
    > news:6212401e18c53@uwe...
    > > What can cause a relationship to be missing.
    > >
    > > I had a relationship setup between two tables. It had been working fine.
    > > However today I had users complaining about dtatbase issue. When I looked
    > > at
    > > the relationships I found that the link was missing.
    > >
    > > What can cause this issue?
    > >
    > > Matt
    > >
    > > --
    > > Matt Campbell
    > > mattc (at) saunatec [dot] com
    > >
    > > Message posted via AccessMonster.com
    > > http://www.accessmonster.com/Uwe/Forums.aspx/access/200606/1
     
  5. mattc66 via AccessMonster.com

    Guest

    I would like to move to SQL - However I have legacy data that I bring into
    Access via ASC (ascii) and I have not figured out how to do the same with SQL.
    New to SQL..

    dbahooker@hotmail.com wrote:
    >I would reccomend using SQL Server instead of MDB.
    >
    >a) it doesnt just randomly get corrupted
    >b) it is easy to script RI so that you can enforce it on a scheduled
    >basis
    >
    >SQL just has much easier version control than MDB.
    >
    >these days; you can put DDL triggers to table; so that if anyone
    >changes ANYTHING in a table you can rollback changes; etc
    >
    >-Aaron
    >
    >> Hi Matt
    >>

    >[quoted text clipped - 24 lines]
    >> > Matt Campbell
    >> > mattc (at) saunatec [dot] com


    --
    Matt Campbell
    mattc (at) saunatec [dot] com

    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access/200606/1
     

Share This Page