Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Mar 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Synchronize from remote netwrks (2000)

    Hi, all!
    I am looking to run a database (replicas) on two remote networks, and synchronize them daily.
    the reason i want to use replicas is because i have daily update of forms, reports ect.
    The "Help" of access shows me that the solution is "internet synchronization" which can be done with replica manager thats available through Microsoft Office Developer (MOD).
    My questions are as followws:
    1. My understanding of "Internet synchronization" is that all replicas synchronize "into" a replica on an ftp server or something like that. am i right?
    2. Is this the best solotion?
    I will be very appreciative if i can get some advice.
    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Synchronize from remote netwrks (2000)

    Is this a split database, with the tables in one file and the forms, reports, queries, etc., in another? If you have daily updates of forms and reports, that means you want to replicate the front end database, and I advise strongly against that. If the database is not split, I also advise you to split it as soon as possible. That would mean that you could use replication on the data to synchronize changes, but all you would have to do for the front end would be to give them a new one, no synchronization required. Front end synchronization gets very messy fast.
    Charlotte

  3. #3
    New Lounger
    Join Date
    Mar 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Synchronize from remote netwrks (2000)

    Thanx Charlotte,
    I will take your advise regarding splitting the database.
    But how will i synchronize the back end (Tables and queries)
    Thanks again
    Mayer

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Synchronize from remote netwrks (2000)

    No, no. Queries are in the front end. Only tables, and their relationships, go in the back end.
    Charlotte

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

    Re: Synchronize from remote netwrks (2000)

    Synchronizing a back-end database works just the same as any other database. The setup/process depends on whether you are doing a manual synch or an automated one.
    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
  •