I have been developing and distributing Access applications to clients for over 15 years. As part of the project development process I meet with the IT rep from each client and explain the installation requirements.
I always specify that each user must have their own copy of the front end application, linked to the backend DB. Up until now this has never been an issue and the installations all were accomplished without issue. I have some clients whose users connect thru Citrx. I am not a hardware/network/communications person at all so I don't completely understand (or care) what this means. However, as with other client's we had out pre-install meeting. I explained how that each user needs their won copy of Access and the IT people implemented that. I think said each user has there own work space and they copy the application accde to each work space.
On my current Access 2013 project with a SQL backend, I recently met with the IT person from the client. They are also using Citrix and will have in the ballpark of 100 users.
When I explained the need for each user to have their own copy of the application, he had an issue. He mentioned zenapp servers, load balancing and some other things I didn't know or care about. He wants every user to use the exact same accde loaded in one place on their network. I explained that wasn't possible because the application used local work tables and global variables. He asked if the application could be modified to not use local work tables and global variables. I explained that large portions of the application would have to be re-written and the project timeline would slide as a result and they were OK with that.
Since the first days of my MS Access development I have been operating under the premise that it is never OK for two users to be using the same front end at the same time. If I do remove local tables and global variables would it be OK to operate in the way IT is proposing. There could theoretically be 100 users using the same physical accde at the same time.
Having of you set up multi-user lient installations where multiple users hit the same accde?
Besides the obvious local tables and global variables are there other specific reasons having all of the users execute the same accde is unacceptable?
This is a very large project and if possible I would like to accomadate the user request. I know it goes against everything I have entered understood about access installations but I really need to present them with objective reasons why their proposed scenario would not work.