Originally Posted by
JoeM
...you want to do each one, one at a time, to monitor it and make sure that the split works properly without any issues or errors...
This is the most important part of Joe's post...there are many things that can prevent the Splitting of a Database, and one or more of these things occur, the attempt to automate the operation would fail and I suspect that you wouldn't be aware of it.
There are a number of hacks on the web to alleviate some of the 'pain' of updating the Front Ends of distributed DBs. Here's guide to one of them
Articlee on Tony Toews' Auto Front End Updater
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007