Hi I have an Access database with the front end on the local computers and the back end on the server. When anyone does a search for a record on our Access 2003 database it takes about 15 seconds to find the record it was taking about 1-2 seconds maximum. This has only just started and we haven?t made any system changes. (It?s been working fine for years).
The server is running on windows 2003 server and is running at about 10%, I have never seen it peak at any more than 25% usage. All 6 computers and the server are less than 2 years old. The system is all set up on 1000 network cards and so is the switch. All computers are on windows XP pro sp2.
All of the IP address are set to static, if I change any of the computers to automatically detect the IP address then when you do a search it only takes about 1-2 seconds as it use to do, but this only lasts for about 5 minutes tops then it goes back to 15 seconds or more. When you change it back to the static address again it works really fast but after a few minutes it goes back to being really slow. We have had 2 IT companies have a look at it but they just go away scratching their heads not knowing what to do to put this right all they say is its flooding the network when ever we do a search, they came to this conclusion after they had installed some software on the server to monitor the network.
Any help, ideas would be very much appreciated.
Regards Bob
