In an effort to minimize network traffic, we're thinking of offloading some database table access to each individual desktop (this is NOT a web based app and there is no intention of making it so). This would only apply to static tables that hardly ever change such as "State", "Department", etc.
Clarification:
Rather than going across the network every time this list needs to be accessed, we're thinking of creating a local Microsoft Access database on each desktop that would house these static tables. This will definitely improve performance. As far as updating these tables in case they do change, we can have a program that will push these changes from the main backend DB to this Access MDB.
Pros and cons are welcomed.
Thanks! Tarek