Results 1 to 10 of 10
  1. #1
    MadTom's Avatar
    MadTom is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Location
    CT and VT
    Posts
    206

    relationships missing?


    Is there anything I could have done that would remove my relationships? Maybe making a copy of form to update DB or running some VBA?
    No big deal, Just want to know if anything will effect or remove them.
    Thanks,
    Tom

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    did you click the ALL RELATIONSHIPS button?
    sometimes they like to hide.

  3. #3
    MadTom's Avatar
    MadTom is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Location
    CT and VT
    Posts
    206
    Sorry I don't see
    ALL RELATIONSHIPS button.

  4. #4
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,566
    Hi Tom

    Database Tools - Relationships and then the Ribbon will show these options:-
    Attached Thumbnails Attached Thumbnails RI All.PNG  

  5. #5
    MadTom's Avatar
    MadTom is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Location
    CT and VT
    Posts
    206
    I found it under
    Database Tools - Relationships and then Design, but not the problem. No relationships! Some how have been removed. Thanks!
    Click image for larger version. 

Name:	Screenshot (7).jpg 
Views:	12 
Size:	57.0 KB 
ID:	40333

  6. #6
    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,725

  7. #7
    MadTom's Avatar
    MadTom is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Location
    CT and VT
    Posts
    206
    Not a split DB. Maybe I saved from a split DB? I do have older copies that have relationships. Have made many changes along the way.
    Thanks

  8. #8
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,566
    Hi Tom

    Can you zip and share the Db to see if anyone else gets the same outcome?

  9. #9
    MadTom's Avatar
    MadTom is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Location
    CT and VT
    Posts
    206
    I could share my DB, but only to see missing relationships. I added the relationships back and no big problem. Just wanted to know what would delete them? Maybe a change in one of my tables? PK haven't changed. I make copies when I make changes.
    Thanks,
    Tom

  10. #10
    MadTom's Avatar
    MadTom is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Location
    CT and VT
    Posts
    206
    Update! Maybe sometime back I wanted to update a table from another DB and I had to delete relationships in order to copy into. newest DB.
    Not a problem now.
    Thanks!
    Tom

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

Similar Threads

  1. Replies: 7
    Last Post: 08-05-2016, 11:53 AM
  2. Replies: 2
    Last Post: 07-27-2016, 10:25 AM
  3. Replies: 4
    Last Post: 01-14-2016, 11:03 AM
  4. Missing Relationships after Database Split
    By Eddy Sincere in forum Database Design
    Replies: 13
    Last Post: 07-28-2014, 10:45 AM
  5. Explicit Relationships and Implicit Relationships
    By Dazza666 in forum Database Design
    Replies: 2
    Last Post: 07-17-2013, 02:11 AM

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