Hm. "believe" is one of those words that triggers an alert response for me.Hi,
I 've been wondering if it's better to have my FE file in each computer that uses the application or have it on a shared folder on our local windows server?
What do you believe?
Hmm, I wait for experienced citrix users to respond to that.When my client had his FE on his c drive, it didn't work. Their IT guy said it's because Access is on Citrix and he has to open Access and then his FE.
@GPGeorge - "conclusions based on evidence". I'm not coming up with a good word for the latter, but the phrase should suffice.
@AngelSpeaks - Their IT guy said it's because Access is on Citrix and he has to open Access and then his FE.
I don't know anything about Citrix, but it's the same thing with Excel, Word, Adobe, etc. You have to go to Citrix, then File Explorer, and then if you click on the files, the application will open. File Explorer on the c drive doesn't even show you the correct extension of the file. That is on client's desktop.@npa3000 - Pat's comment is simple. Having a local copy of the FE means nobody else is competing for the locks of the FE because they are on a private (non-shared) machine. Those locks, because they relate to local files, are resolved at memory speed rather than network speed.
I believe either "inference" or "deduction" might work here, depending on the strength and nature of the evidence in question.
It would have been nice for the IT guy to know enough to realize that if Access is installed correctly on the CITRIX server (and has the appropriate multi-user licensing), double-clicking the FE's icon will still launch it correctly. Though in this case, I will defer to Pat Harman, because she has more experience in CITRIX cases than I have. It is bad enough that IT guys don't know enough about Access to appreciate it for what it is, but then to have them ALSO not know enough about CITRIX to make it easily usable with Office applications... Sheesh!
Are they using Thin or Thick Clients?I don't know anything about Citrix, but it's the same thing with Excel, Word, Adobe, etc. You have to go to Citrix, then File Explorer, and then if you click on the files, the application will open. File Explorer on the c drive doesn't even show you the correct extension of the file. That is on client's desktop.
Thanks for the great explanation.with Citrix and terminal server the server has profiles for each user - in the same way a computer C drive can contain multiple user profiles (desktop/my docs/etc)
So you would store the FE in each user profile on the server, not on their local machine. Main benefits are performance (almost equivalent to a user having the FE and BE on their local machine), connect from anywhere and from any device that supports remote desktop (includes iOS and Linux OS) which is used to connect to either system. Only real disadvantage I have come across is a user can disconnect from the server, leaving their access app running - but that also has the benefit that if there is an unintended disconnect (power outage, network interruption) the app remains running so will be in the same state when the user logs in again - although there may be a timeout for the app to close if left too long.
md %USERPROFILE%\DwgLog del %USERPROFILE%\DwgLog\DrawingLog.accdb copy "\\BSCCTIMBERLINE1\Timberline Office\AccessApps\Data\CommonFE\DrawingLog.accdb" %USERPROFILE%\DwgLog %USERPROFILE%\DwgLog\DrawingLog.accdb