Solved

Folderredirection + Roaming profiles + MS Access

Posted on 2012-03-12
5
440 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 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

756 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