I have an Access aplication (Front End - Back End) that was working very good in a multiuser environment (Windows XP all computers in the network). Although it was not really neccessery we recently replaced our XP server with 2003 Server and 100 MB network is replaced with 1 GB domain network and my software configuration remained the same(Front end - Back End) NOW I HAVE THE FOLLOWING SITUATION: When only one station in the network is working I have much improved performance compared to previous performance. HOWEVER, If the same program is activated either on server or on any of other stations (Activated but doing NOTHING- only login form) the performance is three times degraded.There must be something I am missing here. I DESPERATLY NEED HELP! -- Message posted via http://www.accessmonster.com
When you have only one user, the database is downloaded into your local network cache and runs fine. When you have multiple users, the database is held at the server. Your new server runs much slower because of packet signing. Two resources for tuning your server are: http://msdn.microsoft.com/en-us/library/bb743398.aspx http://support.microsoft.com/kb/889588 Even without tuning your server, you can get most of your performance back by keeping a link to your database open all the time, by keeping a linked form or table open all the time: http://www.granite.ab.ca/access/performancefaq.htm (david) "lou via AccessMonster.com" <u4833@uwe> wrote in message news:87c42b85eb4e6@uwe... >I have an Access aplication (Front End - Back End) that was working very >good > in a multiuser environment (Windows XP all computers in the network). > Although it was not really neccessery we recently replaced our XP server > with 2003 Server and 100 MB network is replaced with 1 GB domain network > and > my software configuration remained the same(Front end - Back End) > NOW I HAVE THE FOLLOWING SITUATION: > When only one station in the network is working I have much improved > performance compared to previous performance. HOWEVER, If the same > program > is activated either on server or on any of > other stations (Activated but doing NOTHING- only login form) the > performance > is three times degraded.There must be something I am missing here. > I DESPERATLY NEED HELP! > > -- > Message posted via http://www.accessmonster.com >
