Avatar of Andy Brown
Andy Brown
Flag for United Kingdom of Great Britain and Northern Ireland asked on

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.
Microsoft AccessWindows Server 2003Windows Server 2008

Avatar of undefined
Last Comment
Andy Brown

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Elmar Koschka

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
borki

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.
Andy Brown

ASKER
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,
SOLUTION
borki

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Andy Brown

ASKER
Thanks guys - really useful info.

I may post another question about the RDP side of things shortly.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck