My office pc took a very long time to connect to database in Access 2003 after updating to Windows XP, a few minutes just to open a simple which normally take less than 10 seconds. Whenever it has to retrieve data from the db, it will be super lagging.



The rest of the workstation running on Windows 2000 were running perfectly fine.

The database is located on the host pc, running Windows 2000.

Initially we suspected that it might be because of the RAM .Thus it was changed from 1GB to 2GB. But even after changing to 2GB, the problem still exists.

Can anyone please advice me on how to check and rectify this problem?