I use a Windows Terminal Server for several of my apps that need to be
accessed over a wide area network. We have an average of 12 to 15 users
connected at any time. With a beefy server, you'll have little if any loss
of performance. I have connected a Citrix server for 20 CPA's running an
Access database from almost anywhere you can think of. I've also built (but
didn't setup) an Access database for a contruction company with 15 to 40
users (varied with time of day). A few points to remember:
1. Always split your application into front and back-ends.
2. Always create a folder for *each* user, so when they login, they go there
to run their app.
3. The data (back-end) can be on a different server, but it should be at the
same physical location as the Citrix server. We also use gigabit network
cards for connections between multiple servers.
4. NEVER allow the Citrix server to shut down with open sessions. Use a good
UPS and a script to make sure all sessions are closed in the event of a
power failure. Failure to do this leaves you open to possible corruption
issues.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access