Results 1 to 8 of 8
  1. #1
    usatraveler is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    5

    Clear Relationships from the Relationships layout screen

    Just getting started with Access and playing around with creating relationships between tables. I noticed that when I was in the Relationships layout area there are tables in there that was from a previous database. This is a brand new from scratch database. I have done the clear layout but when I hit the All Relationships button they come back. How do you go about clearing out those relationships permanently?



    Thanks
    Usatraveler

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    in relationship screen, delete the table. Save.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    There may possibly be an issue with Acc 2016.
    If you are just adding tables to an older database, then any existing relationships could appear.
    If this is a newly created database (brand new via create database) I don't see how any relationships would be present.
    Please tell us specifics about the situation.

  4. #4
    usatraveler is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    5
    I just went in and highlighted and deleted the tables in the relationship screen and did a save. Closed the database and then reopened the database. When I click on All Relationships they show up again. This is crazy. I must be missing something.

  5. #5
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    1) Are the table names in those relationships MSys....? If so, those are MS Access system tables and relationships - and IMO they are best left alone.

    2) Do the relationships you are trying to delete use linked tables? If so, you have to delete them directly in the BE database, even though you can see them in the FE.

    I don't know about A2016, but in A2010, on the relationships ribbon, there is a button labeled "Clear Layout"; this removes all information from the relationships pane, including the system ones.
    Last edited by John_G; 08-05-2016 at 08:11 AM. Reason: Add information

  6. #6
    usatraveler is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    5
    John,
    You got this one. I guess I should have listed the names when I started this thread. MSysNavPaneGroupCategories, MSysNavPaneGroups and NSysNavPaneGroupToObjects. When I searched on the names those are system tables. Appreciate the help from everybody.

  7. #7
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    You can turn off displaying those system files......

  8. #8
    NightWalker's Avatar
    NightWalker is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2016
    Location
    Midwest USA
    Posts
    253
    usatraveler,

    Here is the link I used to turn those off. http://answers.microsoft.com/en-us/o...88cf957?auth=1

    Hope this helps.

    Walker

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 07-27-2016, 10:25 AM
  2. New DB with many to many relationships
    By DannyBoy in forum Database Design
    Replies: 1
    Last Post: 08-06-2013, 01:38 PM
  3. Explicit Relationships and Implicit Relationships
    By Dazza666 in forum Database Design
    Replies: 2
    Last Post: 07-17-2013, 02:11 AM
  4. Relationships - 1-1 or ???
    By RobFlag in forum Access
    Replies: 3
    Last Post: 03-21-2013, 02:36 PM
  5. Relationships
    By teza2k06 in forum Database Design
    Replies: 1
    Last Post: 03-08-2013, 03:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums