Link to home
Start Free TrialLog in
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

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

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?
ASKER CERTIFIED SOLUTION
Avatar of Daniel Pineault
Daniel Pineault

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
<<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.