We just upgraded our network from peer-to-peer to server-client network. There are 5 workstations all running Win XP Pro. The server is running Small Business Server 2003. Everything seems to be working fine except for a database. When a user tries to access the database, it runs smoothly, but its when another user tries to access the database simultaneously, we run into problems. It seems like the database locks up when there are more than one user. I called Tech support for the software and they told me to include a registry key:
This registry key involves indexes and he said it might be the cause of the problem. I don't want to play with registry settings just yet. He also told me that it might be a security setting on Server 2003. Can someone please help?
The server runs into a switch 10/100mbps which goes to each workstation connected at 100mbps.