Results 1 to 7 of 7
  1. #1
    BrightSoftware is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    45

    Relations between tables disappear

    We have the problem that sometimes the relation between two tables disappear.

    It's in Access 2010 using a accde.
    And the application is multi user with 10-20 users.



    Does anyone know the reason why a relation can disappear?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    if you build the relationships in a non split db with forms and tables, then split the db, the frontend should inherit the relations.
    if you build the relationships in a split db, then deliver the frontend to each user, the relations should remain in the copies.
    Ive never seen them vanish, unless you didnt save the relation upon changing it.

  3. #3
    BrightSoftware is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    45
    The database is split and the frontend is delvired to each user.
    We think the relation sometimes disappear when to users at the same time change the same record.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Quote Originally Posted by BrightSoftware View Post
    The database is split and the frontend is delvired to each user.
    We think the relation sometimes disappear when to users at the same time change the same record.
    ?

    Do you mean each user has their own copy of the ACCDE on their own computer....or a shortcut to the same ACCDE which is shared?
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    BrightSoftware is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    45
    Each user has their own copy of the ACCDE

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Quote Originally Posted by BrightSoftware View Post
    Each user has their own copy of the ACCDE
    ?

    Good.
    Check the record locks on a form control where there is an issue
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  7. #7
    BrightSoftware is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    45
    On a form there is no record locking set.
    In the general settings of access 'Use Row Level Locking' is set True and 'Default Record Locking' is set False

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

Similar Threads

  1. Tables and relations and PK;s and FK''s and FU's
    By Karaline in forum Database Design
    Replies: 4
    Last Post: 02-28-2017, 08:35 AM
  2. Relations between tables
    By pbs in forum Database Design
    Replies: 2
    Last Post: 01-27-2017, 07:33 AM
  3. Replies: 2
    Last Post: 01-08-2017, 04:18 AM
  4. Designing the tables and relations
    By Enzym in forum Database Design
    Replies: 5
    Last Post: 12-29-2014, 08:54 AM
  5. Relations tables
    By azhar2006 in forum Access
    Replies: 6
    Last Post: 08-03-2014, 02:29 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