?
Solved

Folderredirection + Roaming profiles + MS Access

Posted on 2012-03-12
5
Medium Priority
?
447 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 8

Accepted Solution

by:
Elmar-H earned 1200 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 800 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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

743 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