Running on Peer-to-Peer Networks

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

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.