network traffic

[Sam23]

I have a large MS Access 2003 application with underlying SQL 2008 database. Performance is stalling when more than 10 users are on the system due to high network traffic. Each user has their own Access app on the local computer while the data is on the server.

I have several forms that stay open all the time and are invisible if the user is not using them. Almost all data is retrieved using pass through queries.

I am trying to identify what I can do to improve performance. I.E. are all those forms that are invisible holding data that would cause network traffic if they are populated by passthroughs?

A couple of my pulldowns have 4000+ records (name selection list). One thought was to import that data into a local table and populate the list from that. Only problem is that names are added almost daily, so I would have to run a routine to refresh the table every time a name was added.

If the pulldowns are populated by passthroughs, what triggers a refresh? Opening a form would cause a refresh, but does changing tabs on a multitab control?

Thanks for any suggestions.


Sam

[orange]

I have seen these references quoted when performance is in question.
Hopefully they are helpful to you.

http://www.granite.ab.ca/access/performancefaq.htm

http://www.fmsinc.com/microsoftaccess/performance.html