BleepingComputer.com: Access 2007 Not Responding When Multiple Users In Database (vista)

Greetings! I'm a new member and this is my first post - bare with me.

I'm curious if any of you have had issue with Access 2007 on Vista in a multi-user environment. I recently upgraded a clients office from XP to Vista and also upgraded their MS office package to 2007. (They were previously using office 2000).

Their CRM was located within an Access 2000 MDB. Since the installation, the database was upgraded from MDB to ACCDB (2000 to 2007). The database is located on a 2000 server which is a trusted location within the new trust 'feature' of Access. Database size is ~100mb, network is 1000mb.

Performance previously was nearly instant. Since the upgrade, the application will stop responding when switching back and forth between windows (say Internet Explorer then back to Access) for several seconds. Queries that took 1 second now take 45.

I'm kind of stumped at the moment. With one user in the database it works just fine. Performance degrades the more users open the database. I'm sure it has something to do with security settings (either on vista, in the new version of access or both). Please respond if you've ran into a similar issue or can point me in the right direction.

Thanks,
--Jake

Jake the problem isn't your access, it is your network. Vista has a dynamically adjusting IP setting. This is a common problem with Vista/2000 Server. Copy to a command file and right click "run as Administrator" or login in as administrator and start, run, cmd. Type in the dos window.

netsh interface tcp set global rss=disabled
netsh interface tcp set global autotuninglevel=disabled