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

an Access DBMS with NO RELATIONSHIPS?

Discussion in 'Information Technology' started by kt, Jul 28, 2006.

  1. kt

    kt
    Expand Collapse
    Guest

    Hi
    In looking at a database within my new employer and have noticed that there
    are no relationships set up. Some of the tables are linked from external
    databases and many are created ad-hoc by various novice users.
    I have been asked to build reports based on the data in this database - I am
    leary as there are no relationships - leading me to believe the data does not
    have referential integrity and is not reliable.
    Does anyone know if my fear is irrational since many (but not all) of the
    table are linked from an external source (probably star schema warehouse)?
    --
    kt
     
  2. Loading...


  3. Guest

    Guest
    Expand Collapse
    Guest

    In Access, it is not possible to use Declarative Referential Integrity
    on external data. DRI only applies to MDB tables in one MDB
    database.

    In Access, you won't be able to see relationships defined in a
    data warehouse.

    In Access, you can declare relationships between external tables,
    or between external and internal tables, but those relationships
    are meaningless - they are only helpful as guidelines when building
    queries.

    Access is a good platform for building reports based on external
    data.

    The quality of the external data is up to you: Access can't help
    you there.

    (david)


    "kt" <kt@discussions.microsoft.com> wrote in message
    news:1C92F2F5-46CB-473B-8359-50F1C6D98431@microsoft.com...
    > Hi
    > In looking at a database within my new employer and have noticed that

    there
    > are no relationships set up. Some of the tables are linked from external
    > databases and many are created ad-hoc by various novice users.
    > I have been asked to build reports based on the data in this database - I

    am
    > leary as there are no relationships - leading me to believe the data does

    not
    > have referential integrity and is not reliable.
    > Does anyone know if my fear is irrational since many (but not all) of the
    > table are linked from an external source (probably star schema warehouse)?
    > --
    > kt
     
  4. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 8 May 2006 16:11:02 -0700, kt <kt@discussions.microsoft.com>
    wrote:

    >Hi
    >In looking at a database within my new employer and have noticed that there
    >are no relationships set up. Some of the tables are linked from external
    >databases and many are created ad-hoc by various novice users.
    >I have been asked to build reports based on the data in this database - I am
    >leary as there are no relationships - leading me to believe the data does not
    >have referential integrity and is not reliable.
    >Does anyone know if my fear is irrational since many (but not all) of the
    >table are linked from an external source (probably star schema warehouse)?


    You cannot establish relationships with RI enforced to linked tables
    in any case... but you're quite right, unless the relationships are
    enforced *somewhere* (in the data warehouse, in the code which
    extracts the data, or other) then the Garbage In - Garbage Out
    phenomenon will certainly rear its ugly head.

    You might want to do some testing - try the Unmatched Query wizard on
    some pairs of tables which should logically be related, to see if
    there are "orphan" records. I'd be rather surprised if there are not.

    John W. Vinson[MVP]
     
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