Another approach you might use to save you time: instead of rebuilding all the views in one program, have a separate program for each view, and a driver program to run each. That way, you may be able to get a little more sophisticated and only run the views which need to be updated.

That's the approach we use on my current project. However, the basic problem is still there -- if you need to rebuild the entire DBC, it still takes a while (not 20 minutes though!) So we are considering building the DBC into the release app (which installs to each hard drive). It would probably add bulk to the app, but users wouldn't really "see" the increase (since they understand that an upgrade may take some time).
zahid

>Hi
>
>I have a program that recreates all the views in my app, there are around 60 of them, but when I run this program on one of the offices over a 10MB link, it takes an AGE, can anyone give me any idea why it takes seconds on my PC and nearly 20 minutes on the LAN - it shouldn't be that slow, surely.
>
>Thanks
>Kev