Results 1 to 3 of 3
  1. 10-23-2017, 02:28 AM #1
    hellocng
    hellocng is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    3

    Live Update of Datasheets


    I am planning an application where the users will be using forms to update a split database. My question is, if I have a datasheet on a form, would the users see each others' update live, or would there need to be a trigger to refresh, or a refresh button?

    They will be using MS Access Runtime.
    Reply With Quote Reply With Quote
  2. 10-23-2017, 02:48 AM #2
    CJ_London
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,845
    see this link to explain what happens and what you can do

    https://support.office.com/en-us/art...5-a472e742366c
    Reply With Quote Reply With Quote
  3. 10-23-2017, 02:48 AM #3
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,648
    Access will 'refresh' databases on interval set in File > Options > Client Settings > Advanced > Refresh Rate

    Can also manually or programmatically trigger refresh or requery.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Calculating totals from filtered datasheets
    By Tommo in forum Access
    Replies: 3
    Last Post: 09-03-2015, 11:59 AM
  2. Update Linked Excel Datasheets within Access 2010
    By Matze0710 in forum Access
    Replies: 1
    Last Post: 07-13-2015, 02:47 AM
  3. Main form and subform both as datasheets
    By rknapp in forum Forms
    Replies: 4
    Last Post: 04-19-2015, 06:57 PM
  4. Filtering Datasheets
    By Nineseven in forum Access
    Replies: 4
    Last Post: 01-04-2014, 05:38 PM
  5. datasheets and record selection
    By jonny dexter in forum Programming
    Replies: 7
    Last Post: 07-29-2010, 10:46 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums