Results 1 to 5 of 5
  1. #1
    TerraEarth is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Posts
    86

    Flowing updates from master front-end copy to all existing, linked user copies?

    The database in question is split, the front-end is copied from a directory onto the user's computer.



    I have noticed that user's can modify/alter their copy (Add queries, forms, etc) independent of the master copy.

    However, is it possible to alter a form that -should be- shared between all copies (i.e. a form that exists in the master front-end copy itself) and have that update flow to all user-copies?

    For example, I have a form on a front end that is a simply query for a customers table. If I wanted to change one of the text fields from "Plain Text" to "Rich Text" in the master copy, is there a way to flow this update down to all the preexisting user copies? i.e. if this form field property update took place on 3/14/2019, would it flow to the front-end copies that were copied before that date? If not, is there a way to make it so?

  2. #2
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    No. Design changes will not "flow" to other copies of the FE.
    You would have to copy the "New" master FE (after the change) to each of the users computers.

  3. #3
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,372
    This is a very common topic that you can research for ideas, like

    You make a change
    User opens db, which causes comparison of version number.
    If different, they can't open db but they can manually click shortcut get an update or process can be automatic.
    Or a host of variations on the theme, such as nice to have upgrades vs mandatory
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    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,850
    See this material from DevHut (Daniel Pineault) re front end deployment ideas.
    Good luck.

  5. #5
    TerraEarth is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Posts
    86
    Thanks, I will look into that

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

Similar Threads

  1. Replies: 6
    Last Post: 02-16-2016, 09:20 PM
  2. Replies: 5
    Last Post: 08-22-2013, 04:32 PM
  3. Replies: 1
    Last Post: 11-13-2012, 02:27 PM
  4. Database Linked Even If I Make Copies
    By netchie in forum Access
    Replies: 4
    Last Post: 07-22-2011, 11:52 AM
  5. Copy Master Replicant
    By Louis Cherene in forum Access
    Replies: 0
    Last Post: 04-01-2010, 04:01 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