I know this is a longshot since I'm posting in an Access forum but I promised my IT person I would ask for input. I have installed an Access 2003 application on the clients network. The front end is an MDE and the data backend is an MDB resident on the server. The installation is handled by Sagekey.
We have dozens of clients set up with this same configuration. In those cases each user has a copy of the app on their local machine and the data is resident on the server.
Half of the user for the new client are set up in a similar manner, local copy on tier machine, linked to data on the server. Those users are fine. However, this client also has a satellite office with the other half of the users. The satellite users come into the system using Citrix. I don't know Citrix and I am not a communication person but I'll try to relay this as best as I can. As explained to me, on the cirtix side there are two servers the users come in to one or the other. Our application is installed on each server, one time. That means that multiple Citrix users are using the same MDE. A a rule we offload as much as possible to the clients and use local tables to process the selected data. As you might guess, with multiple users using the same MDE, the local tables aren't functioning as they should. If 2 users are using the same local table in the same MDE their data becomes intermingled and the results are incorrect.
My first suggestion was to install a local copy on each machine of the satellite users. The IT person is hesitant to do this because he feels having them connect thru a VPN (whatever that is) would not provide adequate response.
My question: Have any of you EE'ers installed you apps in similar circumstances? If so, what kind of architecture did you use for the remote users?