| Microsoft Office 2000/Visual Basic Programmer's Guide | |
Microsoft Jet supports most file-server and peer-to-peer networks that work on personal computers. However, the performance of a multiuser database system running on a peer-to-peer network may suffer, depending on how the computer that's serving as a file-server is being used. If a workstation that contains a shared database is also being used to run desktop applications, there will be increased levels of disk and network I/O, which will affect performance. Also, if a user runs another application that locks the system, all users sharing the database will lose their connections to the database. This can compromise the integrity of the database. For the best performance and stability on peer-to-peer networks, make sure that a workstation containing a shared database is dedicated solely to that purpose.