modriven
asked on
Database Locking up
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:
[HKEY_LOCAL_MACHINE\System
EnableOpLocks=dword:0
CachedOpenLimit=dword:0
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.
[HKEY_LOCAL_MACHINE\System
EnableOpLocks=dword:0
CachedOpenLimit=dword:0
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.
ASKER
SQL
It could well be just down to the way your application is written. Was it an Access app that has been upsized or something like that?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Oracle, Access,SQLServer....... please clarify?