Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2009
    Posts
    49

    Unanswered: Database without relations

    Hi

    I would like to know if it is possible to create a database without relations?

    what's the advantage

    Thanks & regards

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I suspect that you don't know what relations are, since the question makes no sense. Do you mean relationships?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Feb 2009
    Posts
    49
    oops, yes that's right relationships. my bad. I was on hurry.
    is that possible?

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Yes it is possible. In fact, you could argue it is easier do build them without relationships. This is one of the reasons why so many do not have them.

    Relationships are one of the core mechanisms for maintaining the integrity of your data.

    The advantage of having no relationships is users can do what they like irrespective of data integrity between tables.
    The disadvantage of having no relationships is users can do what they like irrespective of data integrity between tables.

    GIGO.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    The dis-advantages outweigh any advantage in doing it.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Sep 2006
    Posts
    265
    If you don't use Relationships you have to protect your Primary Keys from alteration. In other words set in stone!

    Simon

  7. #7
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I've always considered relationships in a database a critical component when dealing with financial type applications and auditing of data. Orphaned records will kill any type of good scores on an audit regarding your data totals.

    If you establish them before designing your forms, it will help you troubleshoot form saving data problems.
    Last edited by pkstormy; 02-06-09 at 02:52.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •