Hello All -
What guidance do you have for deploying a split Access database FE? Is it best practice to deploy a separate FE to every user, or is it okay to have a single FE for all users?
Since the answer might be situational, here are some details:
* We expect no more than 24 concurrent users of the FE.
* FE users will view forms to modify data but other permissions will be locked down -- FE users will not modify database objects.
* All (or most) users will be accessing the FE from a local LAN.
* The users are in different locations, but our Citrix environment means they're operating VMs sitting on machines on racks right next to the file server the FE would access.
If the best practice is the deploy a separate FE for all users, what's the best practice way of updating each individual FE?
What guidance do you have for deploying a split Access database FE? Is it best practice to deploy a separate FE to every user, or is it okay to have a single FE for all users?
Since the answer might be situational, here are some details:
* We expect no more than 24 concurrent users of the FE.
* FE users will view forms to modify data but other permissions will be locked down -- FE users will not modify database objects.
* All (or most) users will be accessing the FE from a local LAN.
* The users are in different locations, but our Citrix environment means they're operating VMs sitting on machines on racks right next to the file server the FE would access.
If the best practice is the deploy a separate FE for all users, what's the best practice way of updating each individual FE?