Microsoft Office 2000/Visual Basic Programmer's Guide   

Minimizing Network Traffic for Static Objects

As discussed earlier in this chapter, the location of objects in a multiuser solution has a direct effect on the solution's performance. Consider splitting your database into front-end and back-end databases, as described in "The Two-Database Approach" earlier in this chapter. This will move static objects to each user's local drive.