Results 1 to 4 of 4
  1. #1
    Nikh is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Apr 2016
    Posts
    19

    how To Sync Local Table to Linked Table Periodically


    Hi..,

    I have created database and shared with multiple user on network shared folder in WAN...But it takes too much time and if Internet Service not available then user not able not access database....

    It is possible to Sync Local Table to Linked Table as soon as Internet available or any command that can update data into linked table...

    or is there any other way to handle this issue..

    Thanks in advance

    Nikh

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    You are using access 2013? is this a web app using sharepoint?

  3. #3
    Nikh is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Apr 2016
    Posts
    19
    Quote Originally Posted by Ajax View Post
    You are using access 2013? is this a web app using sharepoint?
    No Currently I Am Using Access 2007 We have assigned Public IP to system and then shared folder to Publicly using creditential...

    how To Sync Local Table to Linked Table Periodically or using query


  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Syncing was dropped from 2007 onwards as a facility, and access is not the right tool for working over a WAN. you would need to create your own method which in principle would be:

    depending on who is updating what, a number of queries

    1. append master with records in local but not in master
    2. append local with records in master but not in local
    3. update master with matching recordIDs in local, but changed in local
    4. update local with matching recordIDs in master but changed in master

    It will be further complicated if you have more than one 'local' user - if two separate 'local' users change a record since last synced - which one is correct? so you will also need a routine to manage which version is to be retained.

    However if your connection is intermittent a loss of connection while syncing could result in corruption in one or both databases. I would recommend looking at using terminal server or citrix or perhaps move the back end to sharepoint.

    No idea how you would have vba detect if a connection has been restored other than some time routine that regularly 'ping's the master db or server to see if it is available. You might be able to create a listener event of some sort but that is a skill I do not have.

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

Similar Threads

  1. Replies: 3
    Last Post: 10-08-2015, 01:02 PM
  2. Replies: 3
    Last Post: 01-01-2015, 05:25 PM
  3. How to Create local copy of linked Table
    By behnam in forum Programming
    Replies: 3
    Last Post: 11-20-2014, 05:49 PM
  4. Linked table not in sync
    By roulette6 in forum Access
    Replies: 6
    Last Post: 06-25-2014, 09:15 AM
  5. Replies: 0
    Last Post: 05-21-2012, 11:54 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