Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 455
  • Last Modified:

Folderredirection + Roaming profiles + MS Access

We have an MS Access database that uses the Roaming Profile folder for the front-end and for various temporary files (some of our installations are running on Citrix or RDP and this works really well).  Everything works perfectly, with the exception of PCs that have FolderRedirection enabled.  On those PC we get problems, which appear to be timing & locking issues.

Folder example: C:\Users\Andrew\AppData\Roaming\TS

Is there any way to exclude this folder from FolderRedirection, whilst leaving everything else in tact.  Everything important within this folder is on the server, so it does not need to be synced / backed-up.

Any help would be greatly appreciated.
0
Andy Brown
Asked:
Andy Brown
  • 2
  • 2
2 Solutions
 
Elmar KoschkaIT System EngineerCommented:
0
 
borkiCommented:
Why don't you put the Access DB in the Appdata\local\<company> folder. This is where I put my front ends. I figure there is no need to have them roam and being copied back and forth all the time. Some of my front ends are 20+MB and that makes for a big saving on profile space.

Redirected folder is a different concept and does not necessarily have anything to do with the roaming profile. When set using a GPO, I redirect MyDocuments and desktop to  a server location. I still use roaming profiles, but Documents are no longer part of it.
0
 
Andy BrownDeveloperAuthor Commented:
That's not a bad idea, but I am not sure that Appdata\local\<company> would work correctly on Cirtix/RDP setups. I may be wrong,
0
 
borkiCommented:
Works fine on RDS server (2008R2) for two of my clients. Front end runs either on local PC (Win 7) or on RDS server, connecting to backend (full SQL Server) in a different VM.

I use an install/update script for the front end, used every time the program changes, only makes reference to %LOCALAPPDATA%. Biggest hassle is scripting Trusted Location in Access 2007/2010 on initial install, but once set it works OK.

I have no experience with Citrix.
0
 
Andy BrownDeveloperAuthor Commented:
Thanks guys - really useful info.

I may post another question about the RDP side of things shortly.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now