Unsplitting a database

Topic

New Reply

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!!

Reply | Quote

Replies

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

Reply | Quote

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.

Reply | Quote