Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2008
    Location
    philadelphia, Pennsylvania
    Posts
    72
    Thanks
    11
    Thanked 0 Times in 0 Posts

    Replication errors (2003)

    I have a master on my LAN, and a replica sitting on the LAN of a sub office - I do design changes and a bit of data entry, and sync it up with the replica every evening... the last few times I tried to sync, I got the error message that the sync failed because a design change could not be applied to one of the replicas.
    I stripped out the last table, queries, forms and report I did last, hoping that would be it... but same message comes up - I cant just keeping tearing things apart trying to get back to the place when it worked - is there anyway to trouble shoot the message? Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Replication errors (2003)

    Wouldn't it be easier to discard the replica and create a new one?

    (I've always avoided replication, it seems to be more trouble than it's worth)

  3. #3
    Star Lounger
    Join Date
    Feb 2008
    Location
    philadelphia, Pennsylvania
    Posts
    72
    Thanks
    11
    Thanked 0 Times in 0 Posts

    Re: Replication errors (2003)

    Did not think of that <img src=/S/doh.gif border=0 alt=doh width=15 height=15> - I will just need to append a few days new data from the replica to the master.... Unfortunately, I am stuck using replicas because our network lines are horrible and the data input is done at a sub office.... Thanks for the info!

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replication errors (2003)

    Despite the official documentation, replication is intended for Jet objects only - tables and queries. It is not intended for forms, reports, etc. So part of your solution will be to split your application into frontend and backend components. Use replication to sync the data (backend) between multiple locations, and use an alternative method to distribute the frontend to your remote locations. Here's a good resource to study:

    http://www.dfenton.com/DFA/Replication/ind...title=Main_Page
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

Posting Permissions

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