Split file environment - Does a full copy of Access need to be installed on the server?

SteveL13
SteveL13 used Ask the Experts™
on
This may be a dumb question but in a split file environment I know the front-end file goes on every user's computer.  And the back-end file is to go on a server and the front-end file is to be linked to the back-end file.  But does a full copy of Access need to be installed on the server?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
President / Owner CARDA Consultants Inc.
Distinguished Expert 2018
No, not on the server, just on the end-users PCs and if they are just using a database, not doing actual development, they can use the free runtime edition and don't even need to paid full version.  Only the developer(s) need the paid full version.  The only thing that goes on the server is the back-end file itself, nothing more.
John TsioumprisSoftware & Systems Engineer
The BE is just a file...doesn't need anything...just the FE needs at least ms Access Runtime.
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
<<But does a full copy of Access need to be installed on the server?>>

 As the others have said, no it does not, but it can make life easier.    You can do a Compact and Repair right on the server then, do design changes in the BE, etc.

However with that said, you'll seldom find an admin that wants to install Office on a server.

One exception to that is RDP/Citrix servers.  Often companies will have one and Office will be installed.  The BE will be located there, along with some type of a directory structure and mapping to give each user their own copy of the FE.

Jim.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial