Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Acess and LiveMesh (2007)

    Anyone have any experience using Live Mesh or something similar to synchronize a Back End in different sites. I am aware of the issue of making sure that you do not have simultaneous changes, but are there any other issues or tips anyone can share?
    Thanks

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Acess and LiveMesh (2007)

    The Live Mesh facility still seems to be in Beta from what I can tell, but it suggests that you can use .accdb and .mdb files. However I would be more than a little skeptical about doing so on a production database. The fly in the ointment here is that replication was removed from Access 2007 for .accdb format database, and there is anecdotal evidence that 2007 doesn't work all that well with replicated .mdb databases. One thing you might consider is using SQL Server backends, but there are issues there as well as the SQL Server Express version cannot publish data, and in general must work with a Standard or Enterprise version of SQL Server to work in a replicated database. I can tell you that replication in SQL Server does work, and is pretty robust. We use it with several of our clients, and while it is complex, it does the job. We see syncronization with distant databases happening in a matter of seconds across the Internet.

    If you are in a position to do some testing with the Live Mesh environment and Access database, I, and I'm sure many of the regular followers of this forum, would love to know about your experiences.
    Wendell

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Acess and LiveMesh (2007)

    I am going to try it in stages, but first I need to get my main computer repaired so it will take a some time. Thanks for the encouragement.
    If I am using accdb and there is no replication support, then I am really unable to have concurrent usage? Is that correct?

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Acess and LiveMesh (2007)

    Well, in theory, on a website several people can simultaneously work with and Access database, whether is in the .mdb or the .accdb format. And the Live environment is effectively a website, so if the database is only accessed in one physical location, that should work. However if you have a copy on your PC, there is a copy on the Live website, and another person has a copy on his PC, then I don't see how .accdb databases could be kept in sync. The .mdb format can do that, although it is complex and the resolution of conflicts is a real challenge.
    Wendell

Posting Permissions

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