This database is also built with SDT and Mere Mortals Framework and is physically on a Windows 2003 Server. When one workstation logs into the database, latency is not an issue. As soon as a second workstation logs into the database the speed and response of the application is reduced drastically. Even after the second workstation logs out of the database, the first workstation still experiences latency issues until that workstation logs out of the database and logs back in. Then speed picks back up to normal. Only one workstation can work in the database at a time without any big-time delays.

Any help would be much appreciated. Let me know if you need any more info.