locked
Mirroring MS ACCESS Database : Query RRS feed

  • Question

  • Hi All,

    Can you please help on following quires :

    1.  How to create a Mirror  for MS Access Database  from one location to the another location
    2. How to synchronize mirrored databases

    Thanks in advance,

    Tom


    • Edited by Tom_2013 Thursday, May 9, 2013 2:35 PM
    Thursday, May 9, 2013 2:27 PM

Answers

  • Depends on the version of Access or the file type. If you are using Access 2003 or file type .mdb then you can use replication. Other wise you need to manually code it to work. This is not easy in Access 2007 and later or .accdb file types since replication has been removed. In Access 2003 you can use the Wizard. I don't think the wizard is available in A2007 and later.

    Someone else may be able to help better on this or try googling:

    How to synchronize mirrored Access .accdb databases

    Here is one result of that search


    Chris Ward

    • Marked as answer by Dummy yoyo Monday, June 3, 2013 5:32 AM
    Thursday, May 9, 2013 2:39 PM