Results 1 to 2 of 2

Unattended Sync

  1. #1
    frowsyone is offline Novice
    Windows XP Access 2000
    Join Date
    Mar 2010
    Posts
    3

    Unattended Sync

    Is it possible to set up our server to sync the replica databases on a set schedule (quarterly) without someone personally executing it. We would like to set up our system so that the data is pulled from our network and sent electronically to the state w/o assistance.

    Any tips/articles/directions would be much appreciated.

    Thanks~

  2. #2
    apr pillai's Avatar
    apr pillai is offline Contributor
    Windows XP Access 2003
    Join Date
    May 2010
    Location
    Alappuzha, India
    Posts
    134

    Unattended Sync

    If you are planning to run the required VBA Code from within a regularly used Database we can write code to cross-check the Sync schedule set in a parameter table and invoke the Sync Program to do the job. You may write the necessary code like the following example for a one way Sync routine or two way Synchronization:

    Code:
    Sub SendChangeToReplicaX()
    
       Dim dbsNorthwind As Database
    
       ' Opens the replicable database Northwind.mdb.
       Set dbsNorthwind = OpenDatabase("Northwind.mdb")
    
       ' Sends data or structural changes to the replica.
       dbsNorthwind.Synchronize "Nwreplica.mdb", _
          dbRepExportChanges
    
       dbsNorthwind.Close
    
    End Sub
    Two way Sync:

    Code:
    Sub TwoWayExchangeX()
    
       Dim dbsNorthwind As Database
    
       Set dbsNorthwind = OpenDatabase("Northwind.mdb")
    
       ' Sends changes made in each replica to the other.
       dbsNorthwind.Synchronize "Nwreplica.mdb", _
          dbRepImpExpChanges
    
       dbsNorthwind.Close
    
    End Sub
    Internet Synchronize:
    Code:
    Sub InternetSynchronizeX()
    
       Dim dbsTemp As Database
    
       Set dbsTemp = OpenDatabase("C:\Data\OrdEntry.mdb")
    
       ' Synchronize the local database with the replica on
       ' the Internet server.
       dbsTemp.Synchronize _
          "www.mycompany.myserver.com" _
          & "/files/Orders.mdb", _
          dbRepImpExpChanges + dbRepSyncInternet
    
       dbsTemp.Close
    
    End Sub
    There is a Blog Post that explains how to send Weekly e-mails automatically (Automated E-Mail Alerts) on schedule without User's intervention. This may give you ideas to write code for your problem.

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

Similar Threads

  1. Replies: 30
    Last Post: 06-26-2011, 09:47 PM
  2. Sync table and file in access
    By erlan501 in forum Import/Export Data
    Replies: 1
    Last Post: 04-30-2010, 01:12 PM
  3. Split Form Sync up
    By jonsuns7 in forum Forms
    Replies: 1
    Last Post: 11-10-2009, 12:56 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
  •  
Tech Forums: Microsoft Office Forums