Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    May 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Relationship Map

    I have an Access 97 back-end database with a relationships map and even when I save the map the next time I open it all the links have vanished. I can make them appear table by table with the show direct button but show all doesn't make them appear. It wasn't always like that. Any ideas?
    Rob

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Relationship Map

    Dear Rob,

    All I can say about this problem is that as far as I can remember, there

  3. #3
    Star Lounger
    Join Date
    May 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Relationship Map

    Believe me, I've tried everything I can think of. I have even created a new database backend, imported all of the tables, created a new map, linked the tables in the map, saved the little <img src=/w3timages/censored.gif alt=[censored] border=0> and heh presto - all gone again.
    I think I've been microshafted!

  4. #4
    Star Lounger
    Join Date
    May 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Relationship Map

    Well it must be one of those things that can't be explained. I tried creating a new database and importing only the tables, rebuilding the relationships and this time it worked. I have no idea what I did differently from the last time I tried it but it worked and that'll do. One thing I did find interesting is that when I imported some of the tables one relationship came with them. Does anyone know where or how the relationships are stored in Access?

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Relationship Map

    Relationships are stored in one of the MSys tables in Access. The layouts are local to the database in which you create them, since they're simply a visual representation of the relationships and not the relationships themselves.

    In a split front-end/back-end database, the relationships between back-end tables are reflected in the front-end, although you won't see the details of referential integrity there. When you import tables, relationships are imported by default, although you can turn that off by clicking the Advanced button and deselecting the relationships option.
    Charlotte

  6. #6
    Star Lounger
    Join Date
    May 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Relationship Map

    Thanks Charlotte. I didn't even look at those options before. It's a form of domestic blindness. <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

Posting Permissions

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