Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page