Results 1 to 4 of 4
  1. #1
    Aemosha is offline Novice
    Windows 8 Access 2013
    Join Date
    Jan 2015
    Posts
    2

    Two MS access databases synchronization…

    Hello everyone

    I have two MS access databases. Each one is updated by using a specific interfaces (the first through the built-in MS access forms while the second through a specific interface)


    Some tables need to be synchronized between those databases which means, for example, if there is any update (add/delete or update) on a table in the first database, the corresponding table on the second database must be updated. What solution/technology would you used to face this problem?


    Here are what I tried to do…




    1. Using linked tables & update them by a data macro (I’ve never used data macro before) >> problem: data macros can’t be used over a linked table (moreover I didn’t like them as they are so limited)


    2. Using VBA to log all the transition into an external log file. Update each database using this file periodically >> problem: I wasn’t able to log the transaction directly from a table (data macro don’t allow vba) which means that for the second database I won’t be able to log anything (instead the first one which I do by my vba code into the forms)


    I sincerely appreciate your consideration of this issue.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Why two databases?

    What do you mean by 'specific interface'?

    What do you mean by 'lined' table?

    Data macros, as you discovered, won't help here.

    Synchronization can be very tricky.

    https://www.accessforums.net/access/...ate-49500.html

    Search forum for more threads on topic.
    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.

  3. #3
    Aemosha is offline Novice
    Windows 8 Access 2013
    Join Date
    Jan 2015
    Posts
    2
    Thank you so much June7 for your response
    Quote Originally Posted by June7 View Post
    Why two databases?
    The choice to have two databases is not mine. The first one used by the POS (point of sale) software & the second is for the accounting system.
    Quote Originally Posted by June7 View Post
    What do you mean by 'specific interface'?
    The interfaces of the POS software. I have no control on those ones.
    [QUOTE=June7;261160]What do you mean by 'lined' table?
    MS access linked table
    Quote Originally Posted by June7 View Post
    Search forum for more threads on topic.
    I did my best before posting & did found nothing, I'll double check anyway..

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Examples in referenced link are just to merge files, all would be new records appended into 'master' db.

    Synchronization for edits of existing records is much more complicated. For a start, review http://www.blueclaw-db.com/broad_int...eplication.htm
    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.

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

Similar Threads

  1. DB synchronization after corruption
    By Spark_GGSE in forum Access
    Replies: 1
    Last Post: 10-02-2012, 10:58 AM
  2. Replies: 12
    Last Post: 06-27-2012, 12:38 PM
  3. Replies: 0
    Last Post: 03-05-2012, 01:07 PM
  4. Synchronization between forms
    By mnsemple83 in forum Forms
    Replies: 5
    Last Post: 07-13-2011, 10:47 AM
  5. subform synchronization
    By bkelly in forum Forms
    Replies: 2
    Last Post: 09-25-2009, 04:51 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