Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2012

    Question Unanswered: VPN offline Access data sync?

    The company I work for is likely going to have a site-to-site VPN setup for their Access database. The problem as I see it is that some employees will not have Internet access and will have to work with a copy of the database while offline.

    What is the easiest way to get this offline copy of the database to sync with the one on the VPN? Keep in mind employees will have their own User ID so their data will always be different from anyone else's.

    I was thinking of devising a method with VBA for Import/ExportText or XML and having it done that way, as I only need to add data to the tables. Would an update query somehow help?

    Thanks for any and all help!

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    centralised Access over a VPN is not a smart idea, edpecially if yu are the effective systme adminstrator

    far beeter woudlbe to have remote Access DB's and use replciation
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Mar 2012
    I current have 3 companies I work with that have their Access on VPN, and those have quite a few problems. The biggest is the speed that the person is working with at their home or hotel, if it is even slightly slow it slows everyone within the database. Also if one person get locked up from a slow connection it slows everyone's connection. Also if you have the backend sitting on a sql server you come into other problems, people tend to get locked out of the server due to trusted networks. Talk to your sql server admins first about what the need to do to the server for that process as well!

  4. #4
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Albert Kallal has an often quoted article on the subject of WANs/VPNs and Access at

    MS Access on a WAN?

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts