Solved

Folderredirection + Roaming profiles + MS Access

Posted on 2012-03-12
5
436 Views
Last Modified: 2012-03-13
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
Comment
Question by:Andy Brown
  • 2
  • 2
5 Comments
 
LVL 8

Accepted Solution

by:
Elmar-H earned 300 total points
ID: 37708713
0
 
LVL 9

Expert Comment

by:borki
ID: 37713930
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
 

Author Comment

by:Andy Brown
ID: 37713964
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
 
LVL 9

Assisted Solution

by:borki
borki earned 200 total points
ID: 37714002
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
 

Author Closing Comment

by:Andy Brown
ID: 37714117
Thanks guys - really useful info.

I may post another question about the RDP side of things shortly.
0

Featured Post

Are your end users making ugly email signatures?

Have you left it up to your end users to create their own email signatures? Are they forgetting to add the company logo or using garish font colors? Take control and ensure all users have the same email signature.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now