Results 1 to 3 of 3
  1. #1
    alan keen
    Guest

    Unsplitting a database

    I have an Access 2000 database which is split. I now want to change to replicate databases, but how do I unsplit?

    Any help gratefully received!!

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unsplitting a database

    Delete all the links to the tables in the back-end, and then import all the tables from the back-end.

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

    Re: Unsplitting a database

    You don't want to merge them back. Just replicate the back end. You'll have far more problems with updating the design master if you have both front end design changes and back end data to handle in synchronizations. Leaving them separate is a far better idea. You can always distribute new front ends without disturbing the replicated back end. I have used front-end replication, but it has problems and requires a lot of maintenance.
    Charlotte

Posting Permissions

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